Thread: Db2 User Rights Configuration ?
07-15-09, 02:13 #1Registered User
- Join Date
- Mar 2009
Unanswered: Db2 User Rights Configuration ?
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 ?
07-15-09, 07:38 #2:-)
Provided Answers: 1
- Join Date
- Jun 2003
- Toronto, Canada
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.