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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-22 : 10:03:18
|
| ron writes "When a user is added to dbo or to a custom role, why do those permissions assigned to that role not appear as active (or checked boxes) for that user under the permssissions of that object? The same is true with datawriter or whatever, when a user is added to that role. On a related note, if a user is added to the dbo role, that user should have all admin and data access, yes? Mine did not, but it did perform it's "select" related task when checking the select permsission manually. thanks " |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-01-22 : 12:05:46
|
| I would guess it is because the user is inheriting permissions from the role - it has not been given the permissions explicitely. If the user is removed from the role you wouldn't expect it to retain the permissions.Which permissions was the user missing?==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Permissions