Smith works as an Administrator for TestKing Inc. The company has a SQL Server 2008
computer that contains many securables. Every SQL Server securable has associated
permissions that can be granted to a principal. Smith wants to retrieve description of the
built-in permissions hierarchy of the server.
Which of the following functions should Smith use to accomplish the task?
A.
HAS_PERMS_BY_NAME
B.
fn_my_permissions
C.
fn_object_permission
D.
sys.fn_builtin_permissions