=============================================================
Get DB2 Authorizations
=============================================================
To Report the authorities of the current user from values found in the database configuration file and
the authorization system catalog view (SYSCAT.DBAUTH). use “db2 get authorizations”
[db2inst1@mercury ~]$ db2 get authorizations |
ScreenShot : Get the Db2 Authorizations
NOTE : The GET AUTHORIZATIONS command does not display whether or not the current user holds SECADM authority. To find out who holds SECADM authority, use the following query:
SELECT GRANTEE FROM SYSCAT.DBAUTH
WHERE SECURITYADMAUTH = ‘Y’