Retrieving all names with DBADM authority

The following statement retrieves all authorization names that have been directly granted DBADM authority:

   SELECT DISTINCT GRANTEE, GRANTEETYPE FROM SYSCAT.DBAUTH
      WHERE DBADMAUTH = 'Y'