Permissions on packages and package body
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Permissions on packages and package body

  1. #1
    Join Date
    Dec 1999
    Posts
    217

    Permissions on packages and package body

    What permissions would a user have to have to see packages and package bodies in other users schemas? I have granted the user 'execute any procedure' but that does not seem to fix the issue.

    -Chintz

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Grant SELECT on DBA_SOURCE view, so that user will able to see package/body as well as source code...
    Last edited by Sameer; 12-19-2002 at 02:43 PM.

  3. #3
    Join Date
    Dec 1999
    Posts
    217
    So for any user to see the package body they have to have select on dictionary view? Does that mean they can see all source code in all schemas?

    -Chintz

  4. #4
    Join Date
    Dec 1999
    Posts
    217
    What kind of privilege is that? 'Select on dba_source' is not a system privilege?

    -Chintz

  5. #5
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Yes, to avoid that you can create a view based on dba_objetcs which selects only package & package body names of userB

    F.ex: userA needs to see package/body names of userB.

    Code:
    CREATE view User_B_Packages AS 
    SELECT * FROM DBA_OBJECTS WHERE owner = 'USER_B'
    AND object_type IN ('PACKAGE BODY', 'PACKAGE');
    
    GRANT SELECT ON User_B_Packages to userA;

  6. #6
    Join Date
    Dec 1999
    Posts
    217
    So does that mean Oracle does not provide a permission that lets the user have privileges on packages and package bodies. I thought 'Execute any procedure' covers that.

    -Chintz

  7. #7
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    'Execute any procedure' permits user to execute perticular proc/package of other user.. not to see how many other procs/packages he has..

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