the value 'user' is not working the way I expected

CREATE TABLE RACKSTORE (
RACKSTORE_U INTEGER NOT NULL,
ENTERED_DATE DATE DEFAULT 'NOW' NOT NULL,
ENTERED_BY CHAR(10) DEFAULT USER NOT NULL
);

all rows have the literal 'USER' in the column,
I expected the current connection user name to be there

_________________________________________________________________
Hotmail messages direct to your mobile phone http://www.msn.co.uk/msnmobile