Here we go:
http://www.geocities.com/dba_assist/scripts/show_procedure.html
HTH
GovindanK
-Original Message-
From: Jamadagni, Rajendra;Jamadagni, RajendraSent: 10/1/2003 1:25:33 PMTo: [EMAIL PROTECTED]Subject: RE: Describe privilege on procedures packages
all_arguments
Raj
Hi Govindan
Good thought!!, I was going to suggest the same idea, just to go and get
the description of the package / procedure / function from the
dictionary and then grant access to the dictionary views needed.
One slight flaw with your code though, you have selected from user_%
views but the
Hi!
But if this procedure runs in definer rights under schema where the objects
exist, then it should be possible?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 1:59 PM
Hi Govindan
Good thought!!, I was
Hi Pete
I see another restriction (as i choose to put it) with my code. In OUR setup, we use Packages
"Extensively" (front end being Java).We use RefCursors to send result set to Java.
When you describesuch a package ORACLE describes the structure
of theRef Cursor too which i could not get
all_arguments
Raj
-Original Message-From: Govindan K
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 01, 2003
4:00 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: Describe privilege on procedures packages
Hi Pete
I see another restriction (as i choose
Hi Tanel,
I re-read Govindans post ( slowly this time ) and he does suggest
creating a procedure with this SQL and granting execute privileges on it
to the user, so yes it should work, I stand corrected!
kind regards
Pete
In article [EMAIL PROTECTED], Tanel Poder
[EMAIL PROTECTED] writes
Hi!
This link to AskTom may help.
http://tinyurl.com/p7o1
-Original Message-
Sent: Tuesday, September 30, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
(Reposting from yesterday morning since I had no takers! :)
Hello,
I wanted to give another user access to view my procedures
Yes, that's correct.
Since the only privilege available on a code object is execute, it
doesn't make much sense to allow a user to DESCRIBE the call interface
if the user cannot run it.
--- Gary Jackson [EMAIL PROTECTED] wrote:
(Reposting from yesterday morning since I had no takers! :)
this and grant execute priviliges on it.-Original Message-
From: Gary JacksonSent: 9/30/2003 9:31:29 AMTo: [EMAIL PROTECTED]Subject: Re: Describe privilege on procedures packages(Reposting from yesterday morning since I had no takers! :) Hello, I wanted to give another user access to view my