Re: New audit trigger question

On Fri, 19 Mar 2004 15:07:24 +0100, in comp.databases.oracle.server, Frank van Bortel <fvanbortel_at_netscape.net> scribbled:

>Teresa Redmond wrote:
>
>> Hello again;
>>
>> Here is my trigger:
>>
>> CREATE OR REPLACE TRIGGER AUDIT_TRIGGER
>> AFTER UPDATE OR DELETE
>> ON TABLE_X
>> BEGIN
>> if updating then
>> INSERT INTO audit_table
>> SELECT 'TABLE_X', USER, SYSDATE,
>> s.osuser, s.program, 'UPDATING', s.terminal
>> FROM v$session s, v$sql sq
>> WHERE (S.SQL_ADDRESS = sq.ADDRESS
>> AND S.osuser IS NOT NULL
>> and s.osuser not like '%SYSTEM%');
>> else
>> if deleting then
>> INSERT INTO audit_table
>> SELECT 'TABLE_X', USER, SYSDATE,
>> s.osuser, s.program, 'DELETING', s.terminal
>> FROM v$session s, v$sql sq
>> WHERE (S.SQL_ADDRESS = sq.ADDRESS
>> AND S.osuser IS NOT NULL
>> and s.osuser not like '%SYSTEM%');
>> end if;
>> end if;
>> END audit_trigger;
>>
>> Today's issue: User is developing in Forms 6i, not updating data.
>> Trigger is firing and adding rows to audit_table in the "updating"
>> part of the trigger above. Why would that happen?
>>
>> Thanks so much!
>>
>
>Define "user is developing" in forms, not updating".
>If forms allows updates, doesn't it do a select for update
>when the record is selected and changed?

As in, user has opened Forms Designer, opened a form, connected to the database, but has not selected any records, he's just working on the form. The form doesn't load any records automatically, either; you have to select from a record number from a LOV to get a record before one opens in the form. Does that make sense? I know it's hard to get the idea across.

-- 
Teresa Redmond
Programmer/Analyst III
Anteon Corporation
tredmond at anteon dot com