Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Adding windows user to database

Author  Topic 

vaddi
Posting Yak Master

145 Posts

Posted - 2006-12-03 : 01:08:12
Hello

How can I drop and add a windows NT user in database using a script.

Thanks

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-12-03 : 11:22:31
sp_grantlogin and sp_revokelogin to add or remove the login for the Windows account
sp_grantdbaccess and sp_revokedbaccess to add or remove the database user for the login in a database
Go to Top of Page
   

- Advertisement -