I thought I could check the authorization level for a user by just looking at the sysibm.SYSUSERAUTH table.

However, Express C version DB29v7 does not contain the column AUTHHOWGOT. On other version of DB2 this column will indicate if the user is DBADM, SYSCTRL, DBMAINT, etc.

Anyone how I check the authorization level in Express C?

Thanks.

Look in the Appendix of the SQL Reference Vol 1, which contains a description of the catalog views (SYSCAT schema). Check out all the catalog views with AUTH in them to find what you need.
https://www-304.ibm.com/support/docv...id=swg27015148

There are nine in the auth tables in the syscat none of them give me the authorization level which is what prompted the question.

SYSCAT.DBAUTH
SYSCAT.TABAUTH
SYSCAT.COLAUTH
SYSCAT.INDEXAUTH
SYSCAT.PACKAGEAUTH
SYSCAT.ROUTINEAUTH
SYSCAT.SCHEMAAUTH
SYSCAT.SEQUENCEAUTH
SYSCAT.TBSPACEAUTH

What in SYSCAT.DBAUTH?

DBADM is located in DBAUTH. SYSCTRL, SYSMAINT (and SYSADM, SYSMON) are handled in the dbm cfg using operating system group accounts.

I don't know what manuals you were looking at, but DB2 Linux, UNIX, Windows is a different product than DB2 z/OS or DB2 iSerieis.

I am not sure whether these commands and table functions available in DB2-Express -C. However worth a try.

"GET AUTHORIZATIONS" command
AUTH_LIST_AUTHORITIES_FOR_AUTHID table function.

Also check other admin functions related to DB2 security in "Supported administrative SQL routines and views" section in infocenter.

Thanks,
SK Chandra