If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Db2 User Rights Configuration ?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-15-09, 02:13
asp_crazy_guy asp_crazy_guy is offline
Registered User
 
Join Date: Mar 2009
Posts: 73
Cool 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 ?
Reply With Quote
  #2 (permalink)  
Old 07-15-09, 07:38
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On