限制SQL Server Studio 2008中的特定用户仅查看信息 [英] Restrict the specific user in SQL Server studio 2008 to only see the information

问题描述

i希望在sql server中创建新用户并限制为只有一个数据库拒绝所有权限，除了查看表信息，视图，存储程序





例如：



服务器有4个数据库就像（Development_DB，Test_DB，Prevoius_DB，Client_DB）



如果用户登录用户身份sa，则必须执行所有流程



其他明智的用户登录到新的用户ID像（开发人员）那个时间用户已经完成了所有进程（Development_DB，Test_DB，Previous_DB）数据库除了Client_DB



的目的是避免开发人员修改Current Client_DB。它仅用于查看客户端数据并检查功能，视图和存储过程等结构...



如何执行此操作。



再见

nithya

Hi,

i want to create the new user in sql server and restrict to only one data base to deny all permission except see the table information, view, store procedure


For ex :

Server have 4 data base like ( Development_DB,Test_DB,Prevoius_DB, Client_DB)

in case user login to user id sa on that case have to do all process

Other wise user Login to new User ID Like ( Developer ) that time user have do all process to ( Development_DB,Test_DB, Previous_DB) database except Client_DB

purpose is avoid the developer to modify the Current Client_DB . its only for see the client data and check the structure of function, view, and store procedure,etc...

How to do this.

bye
nithya

推荐答案

http://webhelp.esri.com/arcgisserver/9.3/dotnet/index.htm#users_roles_sql_server.htm [ ^ ]





也尝试这个链接...



http://blog.sqlauthority.com/2008 / 12/27 / sql-server-add-any-user-to-sysadmin-role-add-users-to-system-roles / [ ^ ]

这篇关于限制SQL Server Studio 2008中的特定用户仅查看信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！