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.  

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-l
Received on Wed Jul 29 2009 - 15:41:54 CDT

Original text of this message