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 |
|
denis_the_thief
Aged Yak Warrior
596 Posts |
 Posted - 2014-02-04 : 11:22:10
|
| Is there a Permission to check Permissions?I have read access to a Database. i.e. I can view stored procs and table structures but I can not modify, add or delete. But, I can not view the permissions on objects. I should be able to view Object permissions but I should not be able to set them. Is there a permission for this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-02-04 : 13:08:11
|
| I am not aware of a role/permission that would allow you to view permissions but not change them. You could try querying the system tables though.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Permission to check Permissions