Very Computer

How can I setup usernames and passwords for the Desktop engine without
having the Entreprise Manager installed?

Thanks,
Cedric

--add SQL Authentication login
EXEC sp_addlogin 'MyLogin', 'MyPassword'
EXEC sp_defaultdb 'MyLogin', 'MyDatabase'

--add Windows Authentication login (existing Windows user)
EXEC sp_grantlogin 'MyDomain\MyLogin'
EXEC sp_defaultdb 'MyDomain\MyLogin', 'MyDatabase'

USE MyDatabase

--setup object permissions
EXEC sp_addrole 'MyRole'
GRANT ALL ON MyTable TO MyRole

--grant database access
EXEC sp_grantdbaccess 'MyLogin'
EXEC sp_grantdbaccess 'MyDomain\MyLogin'

--add role membership
EXEC sp_addrolemember 'MyRole', 'MyLogin'
EXEC sp_addrolemember 'MyRole', 'MyDomain\MyLogin'

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy  Neil Pike):

http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

Quote:> Hi,

> How can I setup usernames and passwords for the Desktop engine without
> having the Entreprise Manager installed?

> Thanks,
> Cedric

Cedric