如何在SQL Server 2008中创建两个具有不同权限的用户? [英] How to create two users in SQL server 2008 having different rights?

问题描述

我的要求是，我想在Microsoft SQL Server Management Studio 2008中创建两个数据库用户.一个是具有维护，备份计划等活动权限的"sa"用户，另一个是"dbuser"用户.现在，我希望"dbuser"只能看到表和存储过程之类的数据库结构，而"sa"用户或其他用户可能无权查看我的数据库结构.

我对Microsoft SQL Server Management Studio 2008的了解很少，该如何实现呢?请尽快回复.

Hi,
My requirement is, I want to create two database users in Microsoft SQL server management studio 2008. One is ‘sa’ having rights of maintenance, backup plan etc activities and the other user is ''dbuser''. Now I want that ''dbuser'' can only see database structure such as tables and stored procedure and ‘sa’ user or different user may not have rights to see my database structure.

How can I achieve it as I am having very less knowledge about Microsoft SQL server management studio 2008? Reply soon.

Thanks.

推荐答案

检查下面的链接，了解如何创建新用户.

创建新用户 [

Check the Below link to see how to create a new user.

Creating New User [^]

BR//
Harsha

这篇关于如何在SQL Server 2008中创建两个具有不同权限的用户?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！