Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Check authorization level in DB2 Express C

    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.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2006
    Posts
    119
    Quote Originally Posted by Marcus_A View Post
    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

  4. #4
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    What in SYSCAT.DBAUTH?

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Nov 2010
    Posts
    14
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •