SYSADMAUTH

[BeatrixKiddo]

Hello, I was asked to do an audit on a DB2 installation then requested the query:

SELECT GRANTEE, GRANTEETYPE, SYSADMAUTH FROM SYSIBM.SYSUSERAUTH WHERE SYSADMAUTH <>' ';

but the DBA reports the column SYSADMAUTH does not exist:

db2 describe table SYSIBM.SYSUSERAUTH
Column Type Type
name schema name Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------
GRANTEE SYSIBM VARCHAR 128 0 No
GRANTEETYPE SYSIBM CHARACTER 1 0 No
TABSCHEMA SYSIBM VARCHAR 128 0 No
TABNAME SYSIBM VARCHAR 128 0 No
AUTH_DESC SYSIBM BLOB 2097152 0 No


What I'm missing here? my query correspond to a different version of DB2?

 

[papadi]

I was asked to do an audit on a DB2 installation"

Which release of db2 on which platform are you auditing?

 

[BeatrixKiddo]

DB2 running in HP-UX, guess the tables are named different and also the administrative accounts are heald in other ways...

 

[papadba]

Suggest you ask the local DBA where the electronic copies of db2 admin documentation for that release are located.