Re: UID or username

hi

you can use this sample:
CREATE OR REPLACE TRIGGER trigger_name
after/BEFORE INSERT OR UPADTE ON table_name FOR EACH ROW DECLARE...
BEGIN
  :NEW.colm_name1 := USER;
  :NEW..colm_name2 := SYSDATE;
END trigger_name;
/

thanx
a.jaro
Peter Laursen < ptl_at_edbgruppen.dk> wrote:
> Hi

> I am currently designing a new db. Each table will have two fields
> updated_by and updated_at, which will record who and when the row was last
> changed. The two fields will be maintained by a trigger.
> I thought I would store UID in updated_by, but a coworker of mine thinks it
> is better to store the actual username.

> What are the pro's and con's?

> Thanks
> Peter Laursen

--

					MfG
					Akram JARO                            
					email e9225501_at_fbma.tuwien.ac.at

        Student at the  Vienna University of Technology


******************************************************************************