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,

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 ?

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

Any takers...

mmm..

So, only PMR is going to solve this issue?

Please comment..

Thanks,
R

Did the DBA's belong to the PRODADM group at some point?