Re: RLS with exceptions

I haven't tried this out, but I would have expected the query to return no rows at all and simply re-raise the exception raised by the policy function, as the policy function is executed before the query is parsed.

Can you give us an example of what actually happens ?

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

aowens2325_at_my-deja.com wrote in message <8mn4d9$ilg$1_at_nnrp1.deja.com>...


>I am implementing Oracle's RLS package and I have added user defined

>exceptions to my policy functions.  These user defined exceptions are

>raised when a user does not have permission to execute the statement

>type.  I run a script that attempts to issue select, insert, update and

>delete statements for a user on each table for which the policy has

>been enabled.  After each statement type I check the sql%rowcount.

>I've discovered that if the user defined exception is raised by the

>policy function, the sql%rowcount is not accurate.  Any ideas as to why

>this is happening and how it can be avoided???

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.