0 Replies Latest reply: Apr 15, 2013 8:32 PM by Harvey RSS

    View only access to PL/SQL Objects

    Harvey
      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.