Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2010
    Posts
    153

    Lightbulb Unanswered: Change in One schema affecting other schemas

    Hello,

    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.


    Thank you in advance : )

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    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.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    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.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Sep 2010
    Posts
    153
    Thank you Guys : )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •