Re: New audit trigger question

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?

-- 

Regards,
Frank van Bortel