anyone have a package for creating objects in other schemas?
From: <Jay.Miller_at_tdameritrade.com>
Date: Wed, 29 Jul 2009 16:41:54 -0400
Message-ID: <CA405610095C8F42B6FEBFAAA09A7A2A013A54FD_at_prdkcwsemlmb05.prod-am.ameritrade.com>
Sigh.
Date: Wed, 29 Jul 2009 16:41:54 -0400
Message-ID: <CA405610095C8F42B6FEBFAAA09A7A2A013A54FD_at_prdkcwsemlmb05.prod-am.ameritrade.com>
Sigh.
The new company policy is that developers can neither have the password for schemas nor have CREATE ANY xxx on development databases.
The only remaining option I see (other than having developers call me every 2 minutes to keep putting new iterations of code into dev) is to write a package with procedures to create various types of objects which will be owned by the schema and grant execute on it.
I thought it was worth asking if anyone knows of an already existing version of such a script.
I also considered telling the manager who set the policy that he has to write the script himself but decided that wasn't advisable :).
TIA,
Jay
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 29 2009 - 15:41:54 CDT