RE: [QUARANTINE] Re: developer access to alter procedure

From: Jeff Chirco <JChirco_at_innout.com>
Date: Wed, 8 Feb 2012 21:49:14 +0000
Message-ID: <6D9F00643B733E489E419CB485C966271DA1B8_at_IRVMBX01.innout.corp>

I am not sure if I understand what you mean. Can you give me more detail. Thanks.

From: Tim Gorman [mailto:tim_at_evdbt.com] Sent: Wednesday, February 08, 2012 12:39 PM To: Jeff Chirco; oracle-l_at_freelists.org Subject: [QUARANTINE] Re: developer access to alter procedure Importance: Low

Jeff,

Encapsulate the commands you want to provide within a PL/SQL packaged- or stored-procedure. Then, you can control access to that the way you'd like. You can also build in auditing/tracking, etc.

Hope this helps...

Tim Gorman

consultant => Evergreen Database Technologies, Inc.
postal     => PO Box 352151, Westminster CO 80035
email      => Tim_at_EvDBT.com<mailto:Tim_at_EvDBT.com>
mobile     => +1-303-885-4526
fax        => +1-303-484-3608
Lost Data? => http://www.ora600.be/ for info about DUDE...

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

From: Jeff Chirco [mailto:JChirco_at_innout.com]<mailto:[mailto:JChirco_at_innout.com]> Sent: Wednesday, February 8, 2012 01:27 PM To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: developer access to alter procedure

I would like to give a developer access to alter a specific list of procedures/functions/packages from multiple schemas but I can think of a way to do it. I don't want to give him access to a whole schemas because there are other procedures he should not touch, and I don't want to give him the alter any procedure privilege. Is there any way to do this that I am not thinking of? How come Oracle doesn't have the command: Grant alter on to user; Jeff -- http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 08 2012 - 15:49:14 CST