SELECT
  MAX(BINDADDAUTH        ) BINDADDAUTH          
, MAX(CONNECTAUTH        ) CONNECTAUTH          
, MAX(CREATETABAUTH      ) CREATETABAUTH        
, MAX(DBADMAUTH          ) DBADMAUTH            
, MAX(EXTERNALROUTINEAUTH) EXTERNALROUTINEAUTH  
, MAX(IMPLSCHEMAAUTH     ) IMPLSCHEMAAUTH       
, MAX(LOADAUTH           ) LOADAUTH             
, MAX(NOFENCEAUTH        ) NOFENCEAUTH          
, MAX(QUIESCECONNECTAUTH ) QUIESCECONNECTAUTH   
, MAX(LIBRARYADMAUTH     ) LIBRARYADMAUTH       
, MAX(SECURITYADMAUTH    ) SECURITYADMAUTHFROM 
FROM
(
SELECT D.* 
FROM SYSCAT.DBAUTH D
WHERE D.GRANTEE='DB2USER' AND D.GRANTEETYPE='U'
  UNION ALL
SELECT D.* 
FROM SYSCAT.DBAUTH D, TABLE(AUTH_LIST_GROUPS_FOR_AUTHID('DB2USER')) T
WHERE D.GRANTEE=T.GROUP AND D.GRANTEETYPE='G'
  UNION ALL
SELECT D.* 
FROM SYSCAT.DBAUTH D
WHERE D.GRANTEE='PUBLIC'
) T