开发者

how to restrict sa permission on my database

开发者 https://www.devze.com 2023-03-28 11:24 出处:网络
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 itUse the following to enable

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

精彩评论

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