USER

The USER special register specifies the run-time authorization ID at the current server. The data type of the special register is VARCHAR(18).

The initial value of USER for a new connection is the same as the value of the SYSTEM_USER special register. Its value can be changed by invoking the SET SESSION AUTHORIZATION statement.

Example

Select all notes from the IN_TRAY table that the user placed there himself.

   SELECT * FROM IN_TRAY
     WHERE SOURCE = USER