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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to find what roles have permissions on?

Author  Topic 

Bill_C
Constraint Violating Yak Guru

299 Posts

Posted - 2009-09-21 : 06:39:35
I am looking to find out what roles have permissions on certain tables.
Is there a DMV or whatever set up I can query to get this info?
Thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-09-21 : 07:12:10
This should help you. There is a reply about halfway down that will give you what you need.
http://consultingblogs.emc.com/jamiethomson/archive/2007/02/09/SQL-Server-2005_3A00_-View-all-permissions--_2800_2_2900_.aspx
Go to Top of Page

Bill_C
Constraint Violating Yak Guru

299 Posts

Posted - 2009-09-21 : 07:40:55
Thanks
Go to Top of Page
   

- Advertisement -