Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: groups and users

    Hi All,
    i am using db2 v8.1 ESE on windows.
    m facing problem with providing access to users in db2
    1. is any kind of log entry made while adding or removing users?
    2. any user who is in admingroup automatically gets the admin rights without explicitly adding that user from control center?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    with admingroup, do you mean windows group administrators or any specific group you created and granted admin rights in db2
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2008
    Posts
    131
    with admin group i mean, windows adminstrator group.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    no, only users/groups granted dba authority in db2 will have this authority
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by przytula_guy
    no, only users/groups granted dba authority in db2 will have this authority
    I think this is incorrect. I believe all members of the Administrators group on Windows have SYSADM autority.
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Jul 2008
    Posts
    131
    hi,
    i have verified that not all the users in the windows administrator group gets sysadmin authority. only db2admin has got all the privilges by default and other users can only connect to the database but cannot further access this databases.

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    because db2admin is in the group that has been defined as sysadm group
    db2 get dbm cfg and check
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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