Privileges on Package Body
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Privileges on Package Body

  1. #1
    Join Date
    Feb 2006
    Posts
    37

    Privileges on Package Body

    I have a user with TOAD who want to view the SPECS of a package body from another user.

    Is there any way to grant rights to view the package body to another user.

    The following have not worked:

    EXECUTE ALL
    DBA
    SELECT ANY DICTIONARY
    SELECT_CATALOG_ROLE

  2. #2
    Join Date
    Jan 2001
    Location
    San Diego, CA
    Posts
    81
    if you granted DBA, that means this user can view anything he wants...... or do anything he wants.........(make sure you actually granted this role successfully, however I wouldn't recomment granting DBA role left and right....


    Eugene Roytman

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Have you tried Alter Any Package?
    this space intentionally left blank

  4. #4
    Join Date
    Feb 2006
    Posts
    37
    Supriseingly

    DBA & Alter Any PAckage did not work either.

    Any other suggestions???

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Quote Originally Posted by CENSUSDBA
    Supriseingly

    DBA & Alter Any PAckage did not work either.

    Any other suggestions???
    You might also try execute any package.
    this space intentionally left blank

  6. #6
    Join Date
    Feb 2006
    Posts
    37
    Thx for your help

    Here is the combo that finally worked

    GRANT SELECT ANY DICTIONARY,
    SELECT_CATALOG_ROLE,
    CREATE ANY PROCEDURE TO 'USER';


    { TO VIEW PKG BODIES OF ANOTHER USER }

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what was wrong with 'grant select on dba_source to xxx';

    ??????

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