开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜