467,189 Members | 1,348 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

How to recover db2 instance user's privilege?

I installed a DB2 instance named db2inst1, while the user
db2inst1's DBA privilege revoked by some one by accident.
I want to recove the db2inst1's DBA privilege,
then what should I do?


--
Regards.
Mockey Chen
Email: mo*********@gmail.com
Apr 11 '06 #1
  • viewed: 1610
Share:
2 Replies
Mockey Chen schrieb:
I installed a DB2 instance named db2inst1, while the user
db2inst1's DBA privilege revoked by some one by accident.
I want to recove the db2inst1's DBA privilege,
then what should I do?


There are three possibilities what might have happened:

1. The user "db2inst1" has been removed from the (operating system)
group configured as SYSADM_GROUP in the database managers configuration.

2. The (operating system) group has been removed.

3. The accident included something like "db2 update dbm cfg using
SYSADM_GROUP=somegroup" and db2inst1 is not member of "somegroup"

Conclusion:

1.

If you can still remember which group was configured as "SYSADM_GROUP",
just add db2inst1 to that group (create the group if necessary, eg
db2iadm1). Unfortunately "get dbm cfg" will not work to figure that out
due to limited privileges.

OR

2.

Drop the instance, recreate it and catalog your databases again.
Restoring them should not be necessary (although a fresh backup always
gives a better feeling).

Hint: db2cfexp and db2cfimp are very nice tools to backup/restore and
even edit the (instance)-configuration.

regards,

Norbert
Apr 11 '06 #2
Hi again,

Mockey Chen wrote:
I re-create the instance, and how to know the database name through
the DB2 data directory?


Well, you should at least remember which database you are missing. E.g.
If it was "test" something like

db2 catalog database test

should do.

If you _really_ can't remember the missings database Name, a look at the
name of the corresponding Backup-Image should help.

Best regards,

Norbert
Apr 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by siliconmike | last post: by
5 posts views Thread by Rajani | last post: by
1 post views Thread by jatinder.saundh@gmail.com | last post: by
33 posts views Thread by JamesB | last post: by
3 posts views Thread by S.M.Deshpande@googlemail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.