>Hi!
>Just to be SURE I understand. (I don't have access to Oracle, yet. I am currently working with Oracle DBAs at a remote site, trying to make sure I understand what they are doing.) In your trigger, you just used 'user' without a query to assign it. Mark used a query to retrieve 'user' from 'dual'. Did you omit the query because it is not needed. i.e. 'user' is a system variable that is already set? That's the way I read what you posted. Thanks for your help and patience.
>
>Also, dropping/disabling the triggers: It sounds like the database must be used by only your application. Otherwise, dropping/disabling the triggers could be a problem. Or, can the triggers be disabled just for a user/session?
>Thanks.
>
>BTW, We ARE pursuing getting Oracle in house. Then, I can try out this stuff without bugging you guys so much. <g> (Then, of course, I'll have different questions... but maybe I could even answer some of them too!)

I am not sure you can reference the USER name directly. According to one of the Oracle ref books I have, USER is a pseudo-column and can be accessed the way I did with a SELECT USER FROM DUAL. The system table, DUAL, is just a dummy table that is used when exactly 1 row needs to be returned. It is provided because every SQL requires a FROM clause. So DUAL provides such a table for retrieving such information as the system data, the USER, etc.

Enabling/Disabling a trigger does so universally, not just for the currrent session and/or user.

For developing using Oracle, you can get Oracle Lite or Personal Oracle real cheap from the on-line Oracle store at http://store.oracle.com/