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
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
>H
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 choos
am wondering where to get the details of O_AGENT_DET from? (which dba_view).
HTH
GovindanK<-Original Message->
From: Pete FinniganSent: 10/1/2003 4:02:29 AMTo: [EMAIL PROTECTED]Subject: Re: Describe privilege on procedures & packages Hi Govindan Good thought!!, I wa
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 w
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
ute 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
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 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 &
(Reposting from yesterday morning since I had no takers! :)
Hello,
I wanted to give another user access to view my procedures & packages (just
DESC capability), but it seems that the only way for him to be able to DESC
them is for me to grant execute. Is this correct?? (I guess I have never
ha
Hello,
I wanted to give another user access to view my procedures & packages
(just DESC capability), but it seems that the only way for him to be able to
DESC them is for me to grant execute. Is this correct?? (I guess I have
never had this situation before, it just seems surprising if there i
11 matches
Mail list logo