Thread: 2 users with SYSADM authority
06-22-12, 18:55 #1Registered User
- Join Date
- May 2012
Unanswered: 2 users with SYSADM authority
as I am using IBM DB2 Express-C on my Ubuntu machine, my instance owner user is db2inst1. As known, this user has SYSADM authority. I am thinking about:
db2inst1 (it is me ) wants to grant my brother a SYSADM authority, so that he could learn a little bit about the administration in the instance level.
Is that a good idea?
I read a lot that it`s suggested to just have 1 user with this SYSADM authority, because maybe the instance is a sensitive aspect.
I am asking myself, what other possibly negative effects would occur by having 2 SYSADM users?
If there are 2 SYSADM users, would it be possible, that one user could delete the other user, vise und versa?
Thank you for your comments.
06-24-12, 10:42 #2Registered User
- Join Date
- Sep 2004
It's quite normal to have more than one user with SYSADM authority.
In your case, I would even consider giving that grant to your "normal" userid. So as to not having to use db2inst1 interactively.
Or better yet, create an additional Linux userid to be used as sysadm for DB2, so that you can also use DB2 as a non-ADM user.--_Peter Vanroose,
__IBM Certified Database Administrator, DB2 9 for z/OS
__IBM Certified Application Developer
__ABIS Training and Consulting