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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-08 : 08:02:16
|
| Anthony writes "Is it possible to deny sa access to a database. I have changed the database owner to a different user but still can't deny the sa account access." |
|
|
MuadDBA
628 Posts |
Posted - 2004-06-08 : 09:26:18
|
| any account with the system administrator server role can perform any action on any database. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-08 : 11:03:57
|
| And you won't be able to.Change the password to a very difficult onedsf90asdfglkj34xxxfor examplesave it on paper and put it in a safe...and never use sa again....Brett8-) |
|
|
|
|
|
|
Deny sa user access to database