Database Administration (MOSC)

MOSC Banner

Procedure - read permission

edited Apr 22, 2015 1:13PM in Database Administration (MOSC) 6 commentsAnswered

DB Version:               Oracle 11gR2

OS:                            Linux

RAC:                          5 nodes

Application user:        PXPROD

Several developer would like to have view/read access to Procedure in an production Application schema, so they can compare production procedures with the Dev schema in TOAD.

NOTE: I created a view using FROM sys.obj$ o, sys.source$ s, sys.user$ UNION ALL FROM sys.obj$ o, x$joxfs s, sys.user$ but that did not help the users.

1. How would I grant view / read on all procedures in application schema, so they can user the TOAD utility to compare.

2. As a work around, I created a user just for this purpose - but the test did not work.

Tagged:

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