How to Grant only Rebind previleages to a package?

vinaya kumar · New User Joined: 06 May 2009 Posts: 4 Location: Bangalore

Hi,

I need to grant Rebind access to certain group(a1).

We have multiple regions and each region is associated with their own DB, say a1, a2,a3, a4 etc..each regions are inter-dependent.
To elaborate:
a1 uses the tables associated in other regions and so are bound with packages of a2, a3 etc... but a1 doesn't have privileges to bind packages of a2 or a3, so i need to provide bind access to a1 on a2 and a3.
which i can easily perform;

set current sqlid=a2
grant bind on package a2.x to a1;

But only a2 and a3 should be the owners and have exclusive access on their objects. so i need to provide only rebind access to a1,
so is their any command that helps me to give a1 only the rebind access and not the full bind or any other access.

please suggest asap.

Thanks,
Vinay

Anuj Dhawan · Posted: Tue Sep 29, 2009 4:27 pm

Search on word "Grant" under DB2 part of the Forum. Work through the links you find there, that would be ASAP.

vinaya kumar · New User Joined: 06 May 2009 Posts: 4 Location: Bangalore

Thanks Anuj,

Appreciate your reply.

After running thru' the forum, unable to find specific grant on rebind alone, I did post the request.

So Appreciate if you can reply, if you know about the same.

sushanth bobby · Posted: Wed Sep 30, 2009 3:38 pm

Hi Vinay,

From the way i understand a1, a2, a3 & a4 are collections and x happens to be the package.

You are granting a bind privilege of collection/packages to another collection. Can you tell me by doing this what can you do ?

By the way BIND privilege includes BIND/REBIND/FREE. There is no separate privilege for REBIND alone.

Can you elaborate your requirement, a bit more. It will be easy for the experts here to help you.

Thank You,
Sushanth