You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 configured to support Windows authentication and SQL Server authentication. You have received instruction from the CIO to audit permissions granted to several sensitive tables. You are required to write a stored procedure to retrieve information on the permissions granted the principal to which it was granted and the principal to who granted them. The stored procedure is required to support the server even if you upgrade the SQL server to a newer version. What should you do?
A. The sys.syspermissions should be queried.
B. The sys.fn_builtin_permissions should be queried.
C. The sys.server_permissions should be queried.
D. The sys.database_permissions should be queried.
Answer:D
You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 configured to support Windows authentication and SQL Server authentication. You have received instruction from the CIO to audit permissions granted to several sensitive tables. You are required to write a stored procedure to retrieve information on the permissions granted the principal to which it was granted and the principal to who granted them. The stored procedure is required to support the server even if you upgrade the SQL server to a newer version. What should you do?
A. The sys.syspermissions should be queried. B. The sys.fn_builtin_permissions should be queried. C. The sys.server_permissions should be queried. D. The sys.database_permissions should be queried.