how to restrict sa permission on my database
I have a d开发者_开发知识库atabase installed on my SQL SERVER and I want that no one open it even the super admin. only the person who has the user name password can open it
Use the following to enable or disable the sa account
/* Disable SA Login */
ALTER LOGIN [sa] DISABLE
GO
/* Enable SA Login */
ALTER LOGIN [sa] ENABLE
GO
You can not remove/restrict SA login from any database. This is one of the reason you go for seperate instance, so that you can have your own SA password
精彩评论