Re: Row Level Security (8i)

How do you know that it is being created ?

Are you using a 10730 trace to dump the predicate or some other tool to write the predicate to disc ?

Does the predicate use sys_context() or does it use tables for its security check ? If the former, is the sys_context value perhaps not being set correctly. If the latter, are there any indications in trace files (set sql_trace true) that the referenced tables are definitely NOT being accessed when a 'predicated' query is executed ?

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

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

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Zachary Zebrowski wrote in message <3BB89071.5096BE7_at_mitre.org>...


>Hi All.

>We originally set up a database with working row level security.  Over

>the past four months, "something" has changed, and now the row level

>predicate is not being applied.  I say, not being applied because it is

>still being generated correctly.  Also, the predicate is enabled.  It

>simply is non obvious to me what has happened to make it not work.  If

>you could, send me any ideas as to what might have changed to make

>Oracle 8i not work, reply to news group.

>Thanks

>Zak