Database Administration (MOSC)

MOSC Banner

how to make read only schema can select text of procedure,trigger,function, sequence and job on the

edited Oct 24, 2012 4:19PM in Database Administration (MOSC) 7 commentsAnswered ✓
 Hi,

My user request read only schema to read all objects of a main schema,
For the table /view is quite straightforward to use "grant select on objects to read_user",
but for the procedure,trigger,function, sequence and job, how can I make read only schema can read text of those objects?

I was test "grant select on all_source to read_user" but it looks not work as I can select main schema function text by sys account, but read_user no returns. 

Regards
Sean

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