Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Cool Unanswered: Db2 User Rights Configuration ?

    Hi ,
    We just had a big data theft/disaster in which somebody deleted the whole application of the server

    After recovery we are having trouble with installing local instances of DB2 Express C on developer machines,

    What we did was

    1) Install the client by local administrator user on those machines

    But Now when developers try to use their domain accounts and try to create databases they get authorization errors SQL1092N

    We did some R & D and the only way out of this problem is by adding the domain users to local administrator accounts.

    But its not possible in our case because we don't want to give local administrator rights to the developers due to the data theft and disaster.

    Is there any other way we can get through this problem without having to give admin rights local/domain to the developers ?

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    You will need to enable DB2 extended security, create a local group DB2ADMNS, and add the developer account to that group. More details can be found in the installation manual.
    "It does not work" is not a valid problem statement.

Posting Permissions

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