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 |
|
MorrisK
Yak Posting Veteran
83 Posts |
 Posted - 2007-09-11 : 18:15:21
|
| I was wondering if someone could help me understand something. Does sp_helprotect only list the objects to which a user has explicit permissions? Same as in Enterprise Manager and user properties, only it lists all the objects. Are the objects to which a user has explicit permissions the only ones displayed with a check or X?For example, I have a user that is a member of public, db_datareader, and db_datawriter. However, this user does not appear to have permisssions to any of the objects that are listed in their permissions properties in Enterprise Manager. In spite of how this appears, they are able to do what their role membership indicates they can do.I just find this curious. Any thoughts?Thanks,Kevin |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-11 : 18:21:07
|
| use sp_helprolemember--------------------keeping it simple... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 23:34:14
|
| Is it in db_denydatareader/writer roles? |
|
|
|
MorrisK
Yak Posting Veteran
83 Posts |
Posted - 2007-09-13 : 10:03:53
|
quote:
Originally posted by rmiao
Is it in db_denydatareader/writer roles?
No. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-13 : 23:36:22
|
| Try query syspermissions table to see if have any revoked permission. |
|
|
|
|
|
|
Only explicit permissions listed for users?