Re: Oracle triggers

you can use row-level security

however they were complaining about bugs in this feature

this also can be implemented by creating a view with a plsql function in the where clause

the function would check the user identity and affect what that view returns

Regs
AK

Chuck wrote:

> I am looking for some help with developing an Oracle trigger.
> The trigger has to look at users and only allow them to select certain
> values based on their security. There are two tables involved. When I
> try nested if statements in the trigger, it ignores anything after the
> first if statement or ignores certain users embedded in the trigger.
>
> Any ideas?
Received on Thu Jul 25 2002 - 21:56:54 CDT