Easy onliner to show the users on a DB2 database. First connect to the corresponding database and in a SQL commander give this command:
select char(grantee,8) as grantee, char(granteetype,1) as type, char(dbadmauth,1) as dbadm, char(createtabauth,1) as createtab,
char(bindaddauth,1) as bindadd, char(connectauth,1) as connect,
char(nofenceauth,1) as nofence, char(implschemaauth,1) as implschema,
char(loadauth,1) as load, char(externalroutineauth,1) as extroutine,
char(quiesceconnectauth,1) as quiesceconn,
char(libraryadmauth,1) as libadm, char(securityadmauth,1)
as securityadm from syscat.dbauth order by grantee
Visits: 378