Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# CURRENT\$1USER
CURRENT\$1USER

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\$1USER. 

## Syntax
Syntax

```
current_user
```

## Return type
Return type

CURRENT\$1USER returns a NAME data type and can be cast as a CHAR or VARCHAR string. 

## Usage notes
Usage notes

If a stored procedure was created using the SECURITY DEFINER option of the CREATE\$1PROCEDURE command, when invoking the CURRENT\$1USER function from within the stored procedure, Amazon Redshift returns the user name of the owner of the stored procedure.

## Example
Example

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

```
select current_user;

current_user
--------------
dwuser
(1 row)
```