Is there a way to programmatically create users for SQL server database access?Hi,
Use the below system procedures
1. sp_addlogin (create a Login)
2. sp_adduser (Create a User)
3. sp_addrolemember (To add a db role to user/group)
4. sp_addsrvrolemember (To add a server role to Login)
THanks
Hari
MCDBA
"Me" <anonymous@.discussions.microsoft.com> wrote in message
news:E59E2633-C1CB-44C2-8859-D0D05FC2CF37@.microsoft.com...
> Is there a way to programmatically create users for SQL server database
access?|||Thanks !
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment