Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Permission to see the procedures

RE: Permission to see the procedures

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 11 Feb 2005 10:17:42 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87C56@irvmbxw02>


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
Received on Fri Feb 11 2005 - 13:20:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US