-
How to let users see the package body text from like all_source etc. ?
I have given execute rights to the users on procedure and packages. The users can see the text from all_source on procedure and package specifications but not the package body. The public synonyms have also
been created .
-
What Oracle version?
I've just tried it on my 8.1.7 and I can see the source of package bodies of other schemas that has been granted execute to me from ALL_SOURCE.
SELECT * FROM all_source WHERE type = 'PACKAGE BODY' AND owner = 'SOMEOTHERSCHEMA";
[Edited by jmodic on 07-09-2001 at 10:11 AM]
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
The execute rights were given directly to user as well as to ROLE( which is granted to the user). It does not let the user see package body in 8.0.5.
-
Yeah, you are right! I've checked it on 8.0.5 and you realy can't see the source of the package body granted to you in ALL_SOURCE. Obviously they've changed that somewhere in between 8.05. and 8.1.7....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Give them the role "SELECT_CATALOG_ROLE" and see if they can read it from dba_source, that is if you want them to have this role.
-
I do not want them to query dba_source only the all_source.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|