Example - list current login user's permissions
select object_name(major_id) as object_name,permission_name,state_desc
from sys.database_permissions
where major_id >0 and grantee_principal_id !=0
Example - SQL Server Instance Rights
USE AdventureWorks;
SELECT *
FROM fn_my_permissions(NULL, 'SERVER');
GO
Example - Database Rights
USE AdventureWorks;
SELECT *
FROM fn_my_permissions('AdventureWorks', 'DATABASE');
GO
Example - Table Rights
USE AdventureWorks;
SELECT *
FROM fn_my_permissions('HumanResources.Employee', 'OBJECT')
ORDER BY subentity_name, permission_name ;
GO
