如何在Sql Server中使特定数据库不可见 [英] How to make a particular database invisible in Sql Server

问题描述

Hii all



我的应用程序我有一个数据库，我不希望任何人查看。

什么时候我将附加的.bak文件附加后，用户不应该看到它。

是否可以通过任何方式。请告诉我该怎么做..



谢谢

解决方案

首先，请阅读我的评论。



我建议你阅读： SQL Server中的授权和权限 [ ^ ]及所有相关文章。



详情请见：

在SQL Server上管理用户权限 [ ^ ]

基本的SQL Server安全概念 - 权限和特殊主体：sa，dbo，guest [ ^ ]

第2课：配置数据库对象的权限 [ ^ ]

阅读授予和撤销访问权限如下： http://databases.about.com/od/security /a/accesscontrols.htm [ ^

Hii all

for my application i am having one database which i don't want anyone to view.
when ever i will attach the .bak file of that, after attaching it should not be visible to the users.
Is it possible by any means.please tell me how to do this..

Thank you

解决方案

First of all, please, read my comments.

I would suggest you to read this: Authorization and Permissions in SQL Server[^] and all related articles.

For further information, please, see:
Managing Users Permissions on SQL Server[^]
Basic SQL Server Security concepts - permissions and special principals: sa, dbo, guest[^]
Lesson 2: Configuring Permissions on Database Objects[^]

Read the following on granting and revoking access : http://databases.about.com/od/security/a/accesscontrols.htm[^]

这篇关于如何在Sql Server中使特定数据库不可见的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！