GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
Application Development in PL/SQL
SQL Developer (Not for general SQL/PLSQL questions)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 15, 2013 6:32 PM by Harvey
View only access to PL/SQL Objects
Apr 15, 2013 6:32 PM
Currently Being Moderated
I was having some issue with access and created a thread to get some answers, but found the solution by my self.
Re: View only access to PL/SQL Objects
Problem was: After granting grant select on sys.dba_source to XYZ; user still not able to view pl/sql procedures under left navigation.
Wanted to share the solution here
If you grant the following then you will get the desired outcome.
grant select on SYS.Dba_OBJECTS to XYZ;
grant select on Dba_plsql_object_settings to XYZ;
grant select on sys.dba_source to XYZ;
Track in Communications