On 12/3/2010 12:43 AM, Mercea Paul wrote:

> On 2010.12.02 5:18 PM, samcarleton wrote:
>>
>> We have DB data issue where data is duplicated in two tables. When the
>> first table is updated, a trigger updates the second table.
>>
>>
> I use in trigger something like:
>
> if (current_user<>'SYSDBA') then
> begin
>
> end...
>
> and the sysdba is never used by any user/application
>

Why not use the built-in security mechanisms?

Baffled,

Ann