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 > restricted access

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-07-11, 06:18
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
restricted access

db2 ese on p/linux 9.5 fp8
does anyone know if it is possible to restrict access to db2 for specific users for specific ip-addresses ?
we have application userid's that have different authorities than users
we can see that someone is using this uid to access db2 outside of the application was.
can we force/restrict access for this appluser if not initiated from the was server it should do.
thanks for all answers..
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #2 (permalink)  
Old 12-07-11, 08:30
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
This is not the best approach, but you could use WLM for that: define a workload that identifies the unwanted connection, then use an artificially low threshold for this workload (e.g. CONCURRENTWORKLOADOCCURRENCES > 0) with the STOP EXECUTION action.
Reply With Quote
  #3 (permalink)  
Old 12-07-11, 08:34
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
thanks for the update
I am not very familiar with WLM and I don't know if this is for free..
I will do some reading and check if we can filter these connections as they could be initiated from any ip except the one we know (our WAS)
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
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