Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Grant permission for add user to a database role

Author  Topic 

cshong
Starting Member

8 Posts

Posted - 2010-03-24 : 01:43:26
Lets assume that my database consist of two database roles, named role_A and role_B.

I want to grant permission for the users belong to role_A, to add ONLY THEIR OWN USER NAME to role_B, while they cannot add other people or access other role.

What are the query to do this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-24 : 14:31:03
That is not possible.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -