CURRENT_ROLE

PostgreSQL

Example

SELECT CURRENT_ROLE;

Output

myusername

Explanation

The CURRENT_ROLE function in PostgreSQL returns the name of the current role for the active session. In the output, myusername represents the current role name that the function returned.

SQL Server

Example

SELECT CURRENT_USER;

Output

'username'

Explanation

In this example, the CURRENT_USER function in SQL Server is used to return the name of the user who is currently connected to the database. The output will be the ‘username’ of the currently logged-in user.

Note: SQL Server does not have a CURRENT_ROLE function, but CURRENT_USER or USER can be used to determine the user context in which SQL Server code is running.

Oracle

Example

SELECT CURRENT_ROLE FROM dual;

Output

CONNECT

Explanation

The CURRENT_ROLE is a built-in function in Oracle that returns the name of the active role for the current user session. In the example, it is used to pull the current active role from the dual table, a special one-row, one-column table present by default in all Oracle databases. The output CONNECT is the active role for the current database session.