• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Requesting permissions

If I wanted to see (read only) the contents of a package and/or function, what role or security should I ask the DBAs to grant?
0
patriotpacer
Asked:
patriotpacer
  • 2
  • 2
2 Solutions
 
slightwv (䄆 Netminder) Commented:
If you have execute on the package, you should already have access to the text through ALL_SOURCE:

select text from all_source where name='PACKAGE_NAME' and owner='SOME_OWNER' order by line;

Based on your previous I'm guessing you want access through DBMS_METADATA.

I believe you need: SELECT_CATALOG_ROLE.

This might be a security concern though...  It will allow you to select a LOT of things from the data dictionary.
0
 
slightwv (䄆 Netminder) Commented:
0
 
patriotpacerAuthor Commented:
>>This might be a security concern though

There's a copy version which is a week behind.  I'm going to shoot for permissions to it, as opposed to production.
0
 
patriotpacerAuthor Commented:
thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now