Finding out username

[jdgonzalez]

Hi all,

I'm working on creating a table to hold some production information. One of the pieces I'd like to include is the time it was entered into the db and what login was used to insert the data.

For the date piece I'm thinking I could just use 'sysdate', but what is the function to get the username?

Any help provided would be greatly appreciated.

J.D.

 

[jaggiebunnet]

insert into mytable (mydate, myuser) values (sysdate, user);