Re: UID or username

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 18 Nov 1999 12:52:27 GMT
Message-ID: <01bf31cc$f1c656a0$2c289a0a@apollo>

Akram JARO <e9225501_at_fbma.tuwien.ac.at> skrev i artiklen <810rv2$mi7$1_at_news.tuwien.ac.at>...
> 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;

Hi Akram

I know how to do the trigger. Thanks anyway :)

I need to decide whether to store the userid (a number) or the username (a string).
Say the db is exported and imported what happens to the UID's? Say users are dropped and created, what happens to the UID?

Oh , maybee i should just use em both!

Peter Received on Thu Nov 18 1999 - 06:52:27 CST