Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

CURRENT_USER

Returns the user name of the current "effective" user of the database, as applicable to checking permissions. Usually, this user name will be the same as the session user; however, this can occasionally be changed by superusers.

Note

Do not use trailing parentheses when calling CURRENT_USER.

Syntax

Copy
current_user

Return Type

CURRENT_USER returns a CHAR or VARCHAR string.

Example

The following query returns the name of the current database user:

Copy
select current_user; current_user -------------- dwuser (1 row)