Re: Using FGAC for implementing history

Note in-line

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:40A58861.3BA5_at_yahoo.com...


>

> You can 'fiddle' with the 9i using a parameter like

> "_dynamic_security_predicate" (or something akin to that), but you're

> still stuck with that 'all or nothing' approach

>


_dynamic_rls_policies = true / false

I tried FALSE some time ago.  It made the predicate function
fire once - just once - per parent cursor.  A bit like bind
variable peeking: whoever executed the SQL statement
first had their security predicate attached to it, then everyone
else ran the statement with the same predicate. Not very
secure.