Get DB2 Authorizations


=============================================================
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
getauth

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’

Leave a Reply

Your email address will not be published. Required fields are marked *