Database Administration (MOSC)

MOSC Banner

permissions needed to see package body

edited Sep 11, 2014 5:00AM in Database Administration (MOSC) 11 commentsAnswered

Hi,

I need to create a role for the developers with select on tables/views, but they also need to be able to see the package bodies.

What permission will give them the ability to see package body? 

Does that require EXECUTE ANY PROCEDURE?  

This, in my opinion, is a little bit excessive for developers.  I want to give them only what they need and not more, to protect them from themselves.

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center