-
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
-
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
-
Have you tried Alter Any Package?
-
Supriseingly
DBA & Alter Any PAckage did not work either.
Any other suggestions???
-
Originally Posted by CENSUSDBA
Supriseingly
DBA & Alter Any PAckage did not work either.
Any other suggestions???
You might also try execute any package.
-
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 }
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|