限制我无权访问的数据库项目
我在大型托管提供商网络中创建了一些数据库。当我使用 Microsoft SQL Server Management Studio 2008 R2 连接到 SQL 实例时,我会看到服务器上每个 SQL 数据库的列表。有没有办法告诉 Management Studio 仅显示我有权访问的表?
我在网上发现了一些文章,说拒绝我的用户查看其他数据库的权限。这不是问题,但我认为我无法从我的角度做到这一点。我想解决我的问题,而无需致电我的托管提供商。问候。
I created a few databases within a large hosting provider network. When I use Microsoft SQL Server Management Studio 2008 R2 to connect to the SQL instance I see a list of every SQL database on the server. Is there a way I can tell Management Studio to only display the tables I have access to?
I found a few articles online that said to deny my user the permission to view the other databases. That wouldn't be an issue, except I don't think I can do that from my end. I'd like to solve my problem without having to call my hosting provider. Regards.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
不幸的是,您现在所问的问题是不可能的。我知道这不是您要找的:-)
Unfortunately what you are asking is NOT possible at this time. I know this is NOT what you are looking for :-)