Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2010

    Unanswered: DBADM authority clarification needed


    I'm running DB2 v9.1 FP8 on AIX

    I have user1 who is instance owner. This user belongs to group "db2adm1" (primary group)
    There is another user-user2 who belongs to same primary group:db2adm1

    So user1-instance owner and user2 belongs to same primary group:db2adm1

    My question is :
    If user1 creates a database "testdb", will user2 gets DBADM authority on this database . user2 uses same instance-user1. How do I check for DBADM authority on the database ?


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    is db2adm1 defined as sysamin group in dbm cfg ?
    no you do not get dbadm authority
    connect to database and execute get snapshot for application agentid xxx
    you will see the authorities to have : expl or impl
    also see What's new in DB2 V9.7: System administrator (SYSADM) authority scope has changed
    for sysadm
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Quote Originally Posted by pratapd View Post
    How do I check for DBADM authority on the database ?
    By selecting from SYSCAT.DBAUTH

Posting Permissions

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