SQL_CURRENT_USER

Name

CURRENT_USER  --  Returns the current database username.

Synopsis

   CURRENT_USER 
  

Parameters

This function does not accept parameters.

Results

username

This function returns the name of the current database user.

Description

Use the CURRENT_USER function to retrieve the name of the current user in a string of type name (a 31 character length non-standard type used for storing system identifiers).

Examples

The following example displays the current user.

   SELECT CURRENT_USER AS who_am_i;

   who_am_i
   ------------
   jose