Re: Question: DMBS_RLS Row-level Security Policies

According to the manual (8.1.5 supplied
pl/sql packages) page 41-5:

"

    Dynamic predicates generated out of
    different policies for the same object have     the combined effect of a conjunction (ANDed)     of all the predicates.
"

so you should be able to have multiple active policies all firing and being 'added'. I can't remember if I tested this or not.

--
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.

Mike Jay wrote in message <3BBB36C1.4554E72_at_mitre.org>...


>Off to the book store ;)

>

>Using 'ALTER SYSTEM' in my test instance, I found that only one policy

>function per statements_type would fire.

>

>That is, for MyOwner.MyTable the user MyUser will SELECT against

>the table, but be subject to only one policy with respect to

>the SELECT statement_type EVEN THOUGH two policies pertaining to

>SELECT are defined.

>

>Does this make sense based on y'all's experience?

>