I have DB2 9.7 db2inst1 port 50000 and IP x.x.x.x with Databases A and B
Is there a way to allow certain users to connect ONLY to database B BUT NOT A? that is, to eliminate the possibility that such users get connected to database A?
In other words: is there any possibility to relate e.g. x.x.x.x to Database A (and ONLY A) and x.x.x.y to Database B (and ONLY B)?
(We don't use Control Center any more but DataStudio 3.1.1 instead)
This topic has been locked.
2 replies Latest Post - 2012-11-02T15:37:12Z by SystemAdmin
Pinned topic How to restrict the access to a DB belonging to a multi-DB instance
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-02T15:37:12Z at 2012-11-02T15:37:12Z by SystemAdmin
nivanov1 100000H9H7231 PostsACCEPTED ANSWER
Re: How to restrict the access to a DB belonging to a multi-DB instance2012-11-02T15:08:47Z in response to SystemAdmin> is there any possibility to relate e.g. x.x.x.x to Database A (and ONLY A)
> and x.x.x.y to Database B (and ONLY B)?
No, but you can revoke the CONNECT authority on database B from the users you don't want to be able to connect to it.
SystemAdmin 110000D4XK17917 PostsACCEPTED ANSWER
Re: How to restrict the access to a DB belonging to a multi-DB instance2012-11-02T15:37:12Z in response to SystemAdminHi,
I think if you use Workload Management (WML), you can control this.
Just check the edition you are using, and this command:
As you can see, there are many examples at the end, with the "address" parameter.
This tutorial could guide you in the WML configuration http://www.ibm.com/developerworks/data/tutorials/dm-0908db2workload/section2.html