This discussion is archived
0 Replies Latest reply: Apr 15, 2013 6:32 PM by Harvey RSS

View only access to PL/SQL Objects

Harvey Newbie
Currently Being Moderated
Hi Guys,

I was having some issue with access and created a thread to get some answers, but found the solution by my self.

Original question
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;

Thank you.