What Objects Does The Fn_my_permissions Function Reports On?

1.	What Objects Does The Fn_my_permissions Function Reports On?
Answer» SERVER DATABASE CHEMA OBJECT USER LOGIN ROLE APPLICATION ROLE TYPE MESSAGE TYPE ASYMMETRIC KEY SYMMETRIC KEY CERTIFICATE SERVICE REMOTE SERVICE BINDING FULLTEXT CATALOG ASSEMBLY CONTRACT ENDPOINT ROUTE XML SCHEMA COLLECTION SELECT * FROM fn_my_permissions(NULL, ‘SERVER’); SELECT * FROM fn_my_permissions(‘AdventureWorks’, ‘DATABASE’); SELECT * FROM fn_my_permissions(‘Employee’, ‘OBJECT’) SELECT * FROM fn_my_permissions(NULL, ‘SERVER’); SELECT * FROM fn_my_permissions(‘AdventureWorks’, ‘DATABASE’); SELECT * FROM fn_my_permissions(‘Employee’, ‘OBJECT’)

Answer»

SELECT * FROM fn_my_permissions(NULL, ‘SERVER’);

SELECT * FROM fn_my_permissions(‘AdventureWorks’, ‘DATABASE’);

SELECT * FROM fn_my_permissions(‘Employee’, ‘OBJECT’)

SELECT * FROM fn_my_permissions(NULL, ‘SERVER’);

SELECT * FROM fn_my_permissions(‘AdventureWorks’, ‘DATABASE’);

SELECT * FROM fn_my_permissions(‘Employee’, ‘OBJECT’)

Discussion