package body text for other users
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: package body text for other users

  1. #1
    Join Date
    Mar 2001
    Posts
    20
    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 .





  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  3. #3
    Join Date
    Mar 2001
    Posts
    20
    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.

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  5. #5
    Join Date
    Apr 2001
    Posts
    219
    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.

  6. #6
    Join Date
    Mar 2001
    Posts
    20
    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
  •  


Click Here to Expand Forum to Full Width