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?
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?
To produce a list of all user privileges a user has been granted, the SYSIBMADM.PRIVILEGES view should be queried. This view contains detailed information about all privileges and authorities granted to users, making it the most appropriate source for this information.
I agree, correct answer is C.
The correct answer is C. SYSIBMADM.PRIVILEGES Indeed, the tables SYSIBMADM.GRANTS and SYSCAT.USER_TAB_PRIVS do not exists in Db2. The table syscat.dbauth is used prior to version 9.1. In the version 11.1, you must use sysibmadm.privileges. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/t0005823.html https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/t0005819.html
A is correct. SYSIBMADM.PRIVILEGES don't show things for Users SYSCAT.DBAUTH is valid for 11.5 as well.