Firebird Documentation IndexFirebird 1.5 Language Ref. UpdateContext variables → CURRENT_USER
Firebird Home Firebird Home Prev: CURRENT_TRANSACTIONFirebird Documentation IndexUp: Context variablesNext: DELETING

CURRENT_USER

Tip

Find a more recent version at Firebird 5.0 Language Reference: CURRENT_USER

Available in: DSQL, PSQL

Added in: 1.0

Description: CURRENT_USER is a context variable containing the name of the currently connected user. It is fully equivalent to USER.

Type: VARCHAR(31)

Example: 

create trigger bi_customers for customers before insert as
begin
  New.added_by  = CURRENT_USER;
  New.purchases = 0;
end
Prev: CURRENT_TRANSACTIONFirebird Documentation IndexUp: Context variablesNext: DELETING
Firebird Documentation IndexFirebird 1.5 Language Ref. UpdateContext variables → CURRENT_USER