Solved

Requesting permissions

Posted on 2013-06-13
4
279 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle 12c patching 1 60
PLSQL procedure help with decode and null input params 5 46
oracle 11g 23 49
su - oracle could not open session 6 50
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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now