Re: developer access to alter procedure
- From: "Tim Gorman" <tim@xxxxxxxxx>
- To: JChirco@xxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 08 Feb 2012 20:38:57 +0000
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@xxxxxxxxx
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@xxxxxxxxxx]
Sent: Wednesday, February 8, 2012 01:27 PM
To: oracle-l@xxxxxxxxxxxxx
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--//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
