User Creation in SQL Server Database

angie · June 11th, 2003, 05:42 AM

Need help.. I am new to this. I need to write a script (using C#) to add users (retrieved from Active Directory) to a database in SQL Server. Instead of adding the users manually one by one using the SQL Server Enterprise Manager, how can I do so by using C#?
Thanks alot..
angie

pgtips · June 12th, 2003, 04:32 AM

There are 2 system stored procedures to help you with this:

first you can to run this stored proc against the master db to grant the user a login to the db server (effectively allows them to connect to it)

Code:

EXEC sp_grantlogin 'domain\user'

then you run this one against each database to grant access to each database

Code:

EXEC sp_grantdbaccess 'domain\user', 'user'

I'm afraid I can't give you the c# code to run these stored procs, someone else will have to help you there.

hth
Phil