INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SYSADMAUTH

SYSADMAUTH

(OP)
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?

 

RE: SYSADMAUTH

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

Which release of db2 on which platform are you auditing?

RE: SYSADMAUTH

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

RE: SYSADMAUTH

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close