Home Forums SQL Server 2008 SQL Server 2008 - General Get Public role permissions RE: Get Public role permissions
balasach82
SSCrazy Eights
Points: 9653
More actions
February 27, 2013 at 4:27 am
#1591491
Cadavre
Your query works. Is it the same as the one
select (major_id),OBJECT_NAME(major_id),grantee_principal_id,permission_name,state_desc from sys.database_permissions
where grantee_principal_id=0