Re: Row Level Security (8i)

Your boss's test is only showing that if the procedure is called the correct predicate is returned. He has not proved that the procedure is being called at the right time.

Possibly the policy that used to connect the procedure to the relevant tables has been erased somehow. Check the view DBA_POLICIES (I think that sounds about right)

--
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 <3BB8A78B.73ABFF2B_at_mitre.org>...


>Jonathan Lewis wrote:

>>

>> How do you know that it is being created ?

>

>My boss directly queried the procedure that was generating the predicate

>and it returned the correct info.

>