RE: Permission to see the procedures

create role programmer_role ;
connect sys as sysdba
grant select on dba_source to programmer_role ; grant programmer_role to programmer_user_id ; -----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org
<mailto:oracle-l-bounce_at_freelists.org> ] On Behalf Of Kline.Michael

The select_catalog_role doesn't seem to work. That made sense. Maybe that's why it didn't work.

...
Just need that magic grant that allows "select only" privs to a package/procedure/body.

--
http://www.freelists.org/webpage/oracle-l