Explanation: Use ‘sub name’ instead of ‘[sub name]’. 3. _________ returns a list of the permissions effectively granted to the principal on a securable.
A. HAS_PERMS_BY_NAME
B. sys.fn_my_permissions
C. sys.fn_permissions
D. All of the mentioned
Answer:A
Explanation: Use ‘sub name’ instead of ‘[sub name]’. 3. _________ returns a list of the permissions effectively granted to the principal on a securable.
A. HAS_PERMS_BY_NAME B. sys.fn_my_permissions C. sys.fn_permissions D. All of the mentioned
Explanation:related function is HAS_PERMS_BY_NAME. 4. Syntax for fn_my_permissions function in SQL Server 2014 is :