?
Solved

Requesting permissions

Posted on 2013-06-13
4
Medium Priority
?
284 Views
Last Modified: 2013-10-08
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
Comment
Question by:patriotpacer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 2000 total points
ID: 39244618
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
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39244629
0
 

Author Closing Comment

by:patriotpacer
ID: 39244641
>>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
 

Author Comment

by:patriotpacer
ID: 39555832
thx
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question