RE: Best way to manage developers/schemas

Paula,

You could create a stored package that your developer could call where he would pass in his "create" scripts as a string and it would be created in the schema.

In our development database, our developers can create and recreate stored packages, triggers and views via the "create any" priv. This has not been a problem for us. I still create and alter the tables.

Hope this helps.

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula_Stankus_at_doh.state.fl.us
Sent: Wednesday, May 25, 2005 4:11 PM
To: spikey.mcmarbles_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Best way to manage developers/schemas

My developer wants to have the ability from one login to manage objects in another login (i.e. create table, index, drop table, index). However, there is only a create any ... Drop any... That would be global and that would be really a bad idea. Can I give them access to create/drop just in a specific schema from another schema?

Thanks,
Paula
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu May 26 2005 - 07:37:36 CDT