Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: Sysibm Blessings

    Team,

    INSTOWN is the instance owner ID and got SYSIBM blessings for DBADM.
    How come other DBA's such as JOHN123, APLDDBA1, BEASS12 has DBADM privileges from SYSIBM blessings.

    User DBA12345 got the DBADM priv from INSTOWN(instance owner )

    Please clarify..


    Database privileges for all users on DW_PRD1:

    USER GRANTOR CONNECT CRETAB LOAD DBA IMSCHEMA BIND ROUTINE
    ---------- ---------- ------- --------- ---- --- ---------- ---- -------
    USER1234 JOHN123 N N Y N N N N
    APLDDBA1 SYSIBM Y Y Y Y Y Y Y
    BEASS12 SYSIBM Y Y Y Y Y Y Y
    DBA12345 INSTOWN Y Y Y Y Y Y Y
    DBA99999 SYSIBM Y Y Y Y Y Y Y
    DBA88888 JO12345 N N Y N N N N
    JOHN123 SYSIBM Y Y Y Y Y Y Y
    INSTOWN SYSIBM Y Y Y Y Y Y Y


    Thanks,

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    adm

    check db cfg : db2 get db for database
    and see
    sysadm and other groups
    have you granted dba to a group, instead of a user ?
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    These are all DBM cfg

    SYSADM group name (SYSADM_GROUP) = PRODADM
    SYSCTRL group name (SYSCTRL_GROUP) =
    SYSMAINT group name (SYSMAINT_GROUP) = PRODMAINT
    SYSMON group name (SYSMON_GROUP) = PRODMON

    PRODADM = only instance owner.
    PRODMAINT = all dba's

    Any clue's.. appreciated.

    Thanks,
    R

  4. #4
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    Any takers...

    mmm..

    So, only PMR is going to solve this issue?

    Please comment..

    Thanks,
    R

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did the DBA's belong to the PRODADM group at some point?
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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