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.
| Author |
Topic |
|
jreynolds
Starting Member
3 Posts |
 Posted - 2007-08-09 : 09:21:43
|
| I can't find anything that explicitly allows or prohibits the granting of 1 database role to another database role. Is this possible? Can I grant say db_datareader, db_datawriter and backupoperater to a role I create, say one called prodsupport or something? |
|
|
sshelper
Posting Yak Master
216 Posts |
Posted - 2007-08-09 : 09:42:19
|
| As far as I know, you cannot add a fixed database role to a user-defined role, but you can do the reverse of that... adding a user-defined role as a member of a fixed database role. Look into sp_addrolemember on adding users or roles to another role.SQL Server Helperhttp://www.sql-server-helper.com |
 |
|
|
|
|
|
sql 2000 grant role to another role