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 |
|
swekik
Posting Yak Master
126 Posts |
 Posted - 2009-03-04 : 12:08:53
|
| Can we add a SQLrole to another SQLrole ?Does it inherits the permissions from another role ?EX:I created a user defined role(TEST) and gave some exec permissions to 2 stored procs .I also added the datareader role to the TEST role .I added this role TEST to a user abc.service .Does the abc.service gets the datareader permissions ? |
|
|
subhash chandra
Starting Member
40 Posts |
Posted - 2009-03-04 : 13:29:12
|
| How did you added datareader role to TEST role?If a user is added to more than one role he will have cumulated permission from all roles. |
 |
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2009-03-04 : 13:44:30
|
| I just tested and it is working.That particular user will get all the permissions from the test role. |
|
|
|
|
|
|
Role