Re: Oracle triggers

From: Roger Crowley <rcrowley-enkidu_at_learningframework.com>
Date: Wed, 24 Jul 2002 16:18:25 GMT
Message-ID: <3D3ED351.7050001@learningframework.com>

Just an additional comment. This is one of those Oracle techniques that keeps changing its name ... so if you're searching for help on implementing it, you might have to look for 'Fine-Grained Access' or for the more recent marketing term 'Virtual Private Database'. No matter what the name, you use the DBMS_RLS package as part of your implementation (which I assume stands for the original term, 'Row Level Security').

Roger Crowley - DBA - LearningFramework

Lothar Armbruester wrote:
> 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
>
Received on Wed Jul 24 2002 - 11:18:25 CDT