Hi!


1) Where does 'user' come from (get its value)? I assume dual is an Oracle System table, which is what Mark
queried.

User is the currently connected user in Oracle...
When you connect for example as scott/tiger@orcl
Then do the query
select user from dual;
You will see the name of the currently connected user.
I don't know what it really is .... I think it's and Oracle system variable or something.

Becuase it can be assigned as I mentioned....with
:cuser=user;

That's all I know.....

2) Where is this 'preference' you discussed?

Well the preference is in my VFP application.
When I select user update triggers check box in the program. I execute Oracle code like.
alter trigger tablename_audit_trigger enable;
For all my triggers...

When I deselect the preference ...
alter trigger tablename_audit_trigger disable;

ect...
You can always use enabled and disabled for any trigger ... To give your self this "option".
Or you could choose to drop the entire trigger....

HTH