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

Home -> Community -> Usenet -> c.d.o.server -> Re: Switch off Fine Grained Access Control within database packaged procedures

Re: Switch off Fine Grained Access Control within database packaged procedures

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Tue, 23 Mar 2004 13:55:31 GMT
Message-ID: <406041D3.4329AE1C@remove_spam.peasland.com>


Neil wrote:
>
> All,
>
> Using 8.1.7 DB
>
> Short of switching FGAC off on entry and back on prior to exit exit of every
> procedure is
> there any way to mark the procedure as 'Run as procedure owner, rather than
> the user
> invoking it?
>
> TIA
>
> Neil

Recode the procedure with DEFINERS RIGHTS instead of INVOKER RIGHTS.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Tue Mar 23 2004 - 07:55:31 CST

Original text of this message

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