IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 12

How can you tell what privileges on a table or view have been granted to a user? (Choose two.)

Answer options

• A. db2look with the ""x option
• B. db2pd with the ""auth option
• C. Query the SYSCAT.DBAUTH view
• D. Query the SYSCAT.TABLES view
• E. Query the SYSCAT.TABAUTH view CE

Correct answer:

Explanation

The correct answers, A and E, allow you to gather information about granted privileges. The db2look command with the 'x' option provides detailed privilege information, while querying SYSCAT.TABAUTH specifically lists table and view authorizations. Options B, C, and D do not provide the necessary information about user-specific privileges on tables or views.