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