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

The current user wants to produce a list of all user privileges she has been granted. Which table or view can be queried to produce the desired result?

Answer options

• A. SYSCAT.DBAUTH
• B. SYSIBMADM.GRANTS
• C. SYSIBMADM.PRIVILEGES
• D. SYSCAT.USER_TAB_PRIVS

Correct answer: A

Explanation

The correct answer is A, SYSCAT.DBAUTH, as it contains information regarding the database authority granted to users. The other options, while related to permissions, do not specifically list the overall user privileges granted to the current user in the same way that SYSCAT.DBAUTH does.