Performing multiple actions in one statement
A REBIND or FREE subcommand can name more than one plan or package. If no owner is named, the set of privileges that is associated with the primary ID, the associated role, and the secondary IDs must include the BIND privilege for each object.
Example
Suppose
that a user with a secondary ID of HQFINANCE has the BIND privilege
on plan P1 and that another user with a secondary ID of HQHR has the
BIND privilege on plan P2. Assume that someone with HQFINANCE and
HQHR as secondary authorization IDs issues the following command:
REBIND PLAN(P1,P2)
P1
and P2 are successfully rebound, even though neither the HQFINANCE
nor HQHR has the BIND privilege for both plans.