Solved

Requesting permissions

Posted on 2013-06-13
4
280 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
  • 2
  • 2
4 Comments
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

776 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