Topic
  • 2 replies
  • Latest Post - ‏2012-11-02T15:37:12Z by SystemAdmin
SystemAdmin
SystemAdmin
17917 Posts

Pinned topic How to restrict the access to a DB belonging to a multi-DB instance

‏2012-11-02T14:26:55Z |
Hi all,

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)

Best regards,
Raul
  • nivanov1
    nivanov1
    231 Posts

    Re: How to restrict the access to a DB belonging to a multi-DB instance

    ‏2012-11-02T15:08:47Z  
    > 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
    SystemAdmin
    17917 Posts

    Re: How to restrict the access to a DB belonging to a multi-DB instance

    ‏2012-11-02T15:37:12Z  
    Hi,

    I think if you use Workload Management (WML), you can control this.
    Just check the edition you are using, and this command:
    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0050554.html

    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