sa account

[PAT]

Is it possible to stop the sa account on sql server 2000 from accessing a database.

Odd question I know, but the design of the server is not the best

thanks

[Tinus1959]

Originally Posted by PAT

Is it possible to stop the sa account on sql server 2000 from accessing a database.

Odd question I know, but the design of the server is not the best

thanks

AFAIK the sa is just a user as any other. You could remove his permissions.

[Fergal1982]

sa can be disabled from the security section. right-click on the account, select properties, and tick the login disabled option (i use 2005, so not exactly sure how it looks).

That will stop its access entirely, but if you want to stop its access to a specific database. Not really. the sa account is the full admin account on the server, its in the sysadmin role, and so has access to everything. you could remove it from that, but then what if you really need the sa accounts level of access?

[Fergal1982]

in essence, isnt this like saying, i dont want the domain admins to be able to log onto a server?

If you are using the sa account in a manner where you want to restrict its access in some way, i would suggest you are using it incorrectly