CURRENT_USER

MySQL

CURRENT_USER()

Example

SELECT CURRENT_USER();

Output

'exampleUser@localhost'

Explanation

The CURRENT_USER() function is returning the user name and host name in the format ‘user@hostname’. In this example, the current user is ‘exampleUser’ and the host name is ‘localhost’.

SQL Server

CURRENT_USER()

Example

SELECT CURRENT_USER;

Output

'MyUser'

Explanation

The CURRENT_USER function returns the name of the current user in the SQL Server session. In this case, the returned username is ‘MyUser’.

Oracle

CURRENT_USER

Example

SELECT CURRENT_USER FROM dual;

Output

'SCOTT'

Explanation

The CURRENT_USER function in Oracle returns the name of the user who executed the current SQL statement. In this example, the user “SCOTT” executed the SQL statement.