开发者

SQL Server - access to sys.views for a highly privileged user

开发者 https://www.devze.com 2023-01-01 14:40 出处:网络
I have case where I want a database user to have db_owner privileges with regard to one databases on the server, but be able to see absolutely nothing of other databases on the server, inc开发者_Go百科

I have case where I want a database user to have db_owner privileges with regard to one databases on the server, but be able to see absolutely nothing of other databases on the server, inc开发者_Go百科luding, for example, the sys.databases view. I have tried denying select on this view at the master database level, but this prevents the user even from connecting to the one database that they own. Does anyone know how to accomplish this?

Grateful for any help.


DENY VIEW ANY DATABASES: http://msdn.microsoft.com/en-us/library/ms189077.aspx

0

精彩评论

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

关注公众号