Privileges on Package Body

[CENSUSDBA]

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

[eugene]

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

[gandolf989]

Have you tried Alter Any Package?

[CENSUSDBA]

Supriseingly

DBA & Alter Any PAckage did not work either.

Any other suggestions???

[gandolf989]

Supriseingly

DBA & Alter Any PAckage did not work either.

Any other suggestions???

You might also try execute any package.

[CENSUSDBA]

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 }

[davey23uk]

what was wrong with 'grant select on dba_source to xxx';

??????