在SQLserver2005中隐藏数据库 [英] Hide a Database in SQLserver2005
问题描述
我正在使用Sqlserver2005作为后端，我需要在客户端位置安装.net应用程序.我需要通过应用程序访问数据库.但是我不希望客户端看到SqlServer2005中的数据库及其表，过程.但是他们希望通过应用程序访问数据库.
在这种情况下我想做什么?
要么
1.我想在SQL Server中隐藏数据库
(或)
2.设置数据库的密码/权限
注意:数据库应由应用程序从多个用户访问，
他们无法直接从SQLManagement Studio查看数据库及其对象.
在此先感谢您的宝贵帮助.
--- Karthika
am using Sqlserver2005 as a backend, i need to install my .net application in Client place. i need to access the DB through application. But i dont want the client to see the Database and it''s Tables, procedures in SqlServer2005. But they want to be access the DB thro application.
In this scenario what i want to do?
either
1. i want to hide the DB in SQL Server
(or)
2. Set a Password/Permission for DB
Note: the DB should access by the application from several users,
They could not view the DB and it''s objects directly from SQLManagement studio.
Thanks in Advance for your Valuable Help.......
---Karthika
推荐答案
为您的应用程序创建单独的SQL用户ID.您只需要授予对指定DB的访问权限，而仅授予Application User ID；不是其他用户.希望这能解决问题.
Create a separate SQL User ID for your application. You need to grant the access to the specified DB, only to Application User ID; not other users. Hope, this will resolve the issue.
亲爱的朋友，
这些链接将对您有很大帮助:-
http://www.mssqltips.com/sqlservertip /1718/database-level-permissions-for-sql-server-2005-and-2008/ [ http://www.databasejournal.com/features/mssql/article.php/10894_2246271_2/Managing-Users-Permissions-on-SQL-Server.htm [ http://msdn.microsoft.com/en-us/library/ms178569.aspx [ ^ ]
http://msdn.microsoft.com/en-us/library/ms365317.aspx [ ^ ]
http://msdn.microsoft.com/en-us/library/ff461429.aspx [ ^ ]
http://msdn.microsoft.com/en-us/library/dd301223.aspx [ ^ ]
Dear Friend,
These links will prove to be of much help to you:-
http://www.mssqltips.com/sqlservertip/1718/database-level-permissions-for-sql-server-2005-and-2008/[^]
http://www.databasejournal.com/features/mssql/article.php/10894_2246271_2/Managing-Users-Permissions-on-SQL-Server.htm[^]
http://msdn.microsoft.com/en-us/library/ms178569.aspx[^]
http://msdn.microsoft.com/en-us/library/ms365317.aspx[^]
http://msdn.microsoft.com/en-us/library/ff461429.aspx[^]
http://msdn.microsoft.com/en-us/library/dd301223.aspx[^]
这篇关于在SQLserver2005中隐藏数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
