SQL Server Performance Forum – Threads Archive

permission on roles

Hi, How can i view the permissions granted to a role on certain objects thru query analyzer, i mean is there any stored procedure or a query. Thanks
Bhushan

sp_helprolemember Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

…. post deleted … Sorry, you were asking about permissions assigned to a role …

Hi, sp_helprolemember will actually display which user has been granted which role, what actually iam looking for is list of object level permissions granted to a role. Bhushan

SELECT * FROM
INFORMATION_SCHEMA.TABLE_PRIVILEGES
WHERE GRANTEE in
(SELECT name FROM sysusers WHERE issqlrole = 1) … at least for permissions on tables in the current database.

]]>