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)
 Prevent sa account

Author  Topic 

tuandang
Starting Member

1 Post

Posted - 2003-01-12 : 20:59:46
How can I prevent sa account from doing anything on my database ? Currently my sql server's using mixed mode login.
Thanks for help.
tuandang@saigoncybernet.com

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-01-12 : 21:12:08
You can't prevent it from doing anything, or revoking its permissions, or removing it. Simply change its password to something only you know and something impossible to guess, NEVER give the password to anyone, and do not use sa at all to log in. Make sure everyone who needs admin privileges has their own login with the appropriate permissions.

Go to Top of Page
   

- Advertisement -