Re: Oracle triggers

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?

Hello Chuck,
you may have a look at row level security in the docs. This transparently adds an additional where condition to all selects on a specific table. So you can control which user may see which rows.

I don't think a trigger is the right way to solve your problem since it is not fired on selects (AFAIK).

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de