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.
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
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.
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