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: Galen Boyer <galenboyer_at_hotpop.com>
Date: 23 Mar 2004 14:55:07 -0600
Message-ID: <ud673z3pe.fsf@standardandpoors.com>


On 23 Mar 2004, sybrandb_at_yahoo.com wrote:

> FGAC can't be switched on and off

Semantics, but:

"grant exempt access policy to [schemaname]" turns it off for a particular user.

"revoke exempt access policy from [schemaname]" turns it back on for a particular user.

-- 
Galen Boyer
Received on Tue Mar 23 2004 - 14:55:07 CST

Original text of this message

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