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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement