Here are the queries I developed so far.
FOR DATABASE AUTHORITIES GRANTED TO USERS/GROUPS:
SELECT SUBSTR(NAME,1,9) DATABASE,SUBSTR(GRANTOR,1,8) GRANTOR,
SUBSTR(GRANTEE,1,8) GRANTEE,
CREATETABAUTH,DBADMAUTH,DBCTRLAUTH,DBMAINTAUTH,CREATETSAUTH,
DISPLAYDBAUTH,DROPAUTH,IMAGCOPYAUTH,LOADAUTH,REORGAUTH,RECOVERDBAUTH,
REPAIRAUTH,STARTDBAUTH,STATSAUTH,STOPAUTH
FROM SYSIBM.SYSDBAUTH
WHERE (NAME = 'YOUR DATABASE NAME')
AND (GRANTEE<>''IF you want to exclude some names')
ORDER BY NAME;
FOR SYSTEM PRIVILEGES HELD BY USERS/GROUPS:
SELECT SUBSTR(GRANTOR,1,8) GRANTOR,SUBSTR(GRANTEE,1,8) GRANTEE,
BINDADDAUTH,CREATEDBAAUTH,CREATEDBCAUTH,DISPLAYAUTH,STOPALLAUTH,
SYSADMAUTH,SYSOPRAUTH
FROM SYSIBM.SYSUSERAUTH
WHERE (GRANTEE<>'IF YOU WANT TO EXCLUDE SOME NAME')
ORDER BY GRANTEE ;
FOR TABLE AUTHORITIES GRANTED TO USERS/GROUPS:
SELECT
DISTINCT(SUBSTR(GRANTEE,1,8)) GRANTEE,
SELECTAUTH SELECT,UPDATEAUTH UPDATE,INSERTAUTH INSERT,
DELETEAUTH DEL,ALTERAUTH ALT ,UPDATECOLS UPDCOL
FROM SYSIBM.SYSTABAUTH
WHERE (TCREATOR='NAME YOU WANT TO CHECK' )
AND (GRANTEE<>'TO EXCLUDE SOME NAME')
AND GRANTEETYPE <> 'P'
ORDER BY GRANTEE ;
FOR PRIVILEGES HELD BY USERS/GROUPS OVER PACKAGES:
SELECT SUBSTR(COLLID,1,8) COLLC_NAME,SUBSTR(NAME,1,10) PACKG,
SUBSTR(GRANTOR,1,8) GRANTOR,SUBSTR(GRANTEE,1,8) GRANTEE,GRANTEETYPE,
BINDAUTH,COPYAUTH,EXECUTEAUTH
FROM SYSIBM.SYSPACKAUTH
WHERE (GRANTEE <> 'TO EXCLUDE SOME NAME')
ORDER BY COLLID,NAME;
FOR PRIVILEGES HELD BY USERS/GROUPS OVER APPLICATION PLANS:
SELECT SUBSTR(NAME,1,10) PLAN,
SUBSTR(GRANTOR,1,8) GRANTOR,SUBSTR(GRANTEE,1,8) GRANTEE,
BINDAUTH,EXECUTEAUTH,SUBSTR(CHAR(GRANTEDTS),1,10) DATEGRANTED
FROM SYSIBM.SYSPLANAUTH
WHERE (GRANTEE <> 'TO EXCLUDE SOME NAME')
ORDER BY NAME;
FOR RESOURCE PRIVILEGES HELD BY USERS/GROUPS:
SELECT SUBSTR(NAME,1,10) RESOURCE, OBTYPE,
SUBSTR(GRANTOR,1,8) GRANTOR,SUBSTR(GRANTEE,1,8) GRANTEE
FROM SYSIBM.SYSRESAUTH
WHERE (GRANTEE <> 'NAME TO EXCLUDE')
Thanks.