Unanswered: Change in One schema affecting other schemas
I have 55 schemas on my DB. Since it's a maintenance project, the packages get altered in every 2-3 days. The problem is I update the same thing in all 55 schemas manually and it takes my lifetime on making the same change eveywhere : (
Is there a way to update packages of all schemas on updating / altering the package in a single schema?
Note - all 55 schemas have different username and password.
How about having the package in only one schema, while all the others have a synonym which points to the package? Then you'd modify the package once, and every other schema would see the change immediately.
Agreed. Don't forget to setup a group that has execute privilege on the packages and all 55 schema have a synonym pointing to the base package and have been granted the group that you setup before. I would also put the code in a schema all by it's self so no one can mess with it but the developers.
You do not need a parachute to skydive. You only need a parachute to skydive twice.