RE: Best way to manage developers/schemas
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <Paula_Stankus@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 May 2005 07:32:47 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Wednesday, May 25, 2005 4:11 PM
To: spikey.mcmarbles@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
