Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    5

    Unanswered: Newbie Auth Question(s)

    Hey Folks..
    We have DB2 V9.5 running on AIX. How do I determine the SYSADM userid? Also, which system table do I query to determine what userid has auth to which table? I'm a DB2 z/OS DBA and don't see an equivalent table to SYSIBM.SYSTABAUTH. Thanks in advance.
    Mike D.

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Mike,

    IBM - DB2 Version 9.5 for Linux, UNIX and Windows English manuals

    This should be your first stop. I think in another thread someone has already pointed out a catalog views.

    get dbm cfg -- should give you a list of groups and what access they have. From there if you must know ids in those groups you can do lsgroup group_name (low case)
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Jun 2006
    Posts
    5
    Thanks Cougar.. I did scour through the manuals, just didn't see anything that gave me userid's and table auths. Just sysschemaauth.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check out the system catalog views (SYSCAT.*). You might be interested in SYSCAT.TABAUTH in particular.

    SYSADM authority is usually assigned to a group, so you can check what group it is:

    db2 get dbm cfg | grep SYSADM

    then see who is in that group:

    lsgroup whatevergroupitwas

  5. #5
    Join Date
    Jun 2006
    Posts
    5
    Thank you n i Must be an age thing. I totally missed the TABAUTH table. thanks again!

Posting Permissions

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