Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: 2 users with SYSADM authority

    Hallo everyone,

    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.


  2. #2
    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

Posting Permissions

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