Following statements returns the permission details for the user who is executing the statement.
-- List of Permission at Server Level
SELECT * FROM fn_my_permissions(NULL, 'SERVER')
-- List of Permission at Database Level
SELECT * FROM fn_my_permissions('DB1', 'DATABASE')
-- List of Permission at Object Level
SELECT * FROM fn_my_permissions('Object1', 'OBJECT')
ORDER BY subentity_name, permission_name
It reports:
Entity_Name
Subentity_Name
Permission_Name
No comments:
Post a Comment