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

"Neil" <someone_at_microsoft.com> wrote in message news:<405f9899_at_cpns1.saic.com>...
> 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

Either your question is very unclear or you don't understand what FGAC is.
FGAC can't be switched on and off, it needs to be programmed. If you never programmed anything, you don't have FGAC enabled. Also: all procedures run *by default* as *procedure owner* instead of invoker.
If you never created or replaced the procedure with the authid current_user pragma, it runs with definer rights.

Sybrand Bakker
Senior Oracle DBA Received on Tue Mar 23 2004 - 09:03:29 CST