开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜