SYSTEM_USER

SQL Server

SYSTEM_USER()

Example

SELECT SYSTEM_USER AS 'CurrentUser';

Output

CurrentUser
-----------
sa

Explanation

The SYSTEM_USER function in the provided SQL Server query returns the current system user name. In this example, the system user is ‘sa’.

Oracle

SYSTEM_USER()

Example

SELECT SYSTEM_USER FROM dual;

Output

'OracleUser'

Explanation

The SYSTEM_USER function returns the current Oracle user name. In this case, ‘OracleUser’ is returned as it is the name of the current user.