©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
SQL functionMySQLMariaDB

The CURRENT_ROLE SQL Function in MySQL and MariaDB - Current permission role name

CURRENT_ROLESyntax:CURRENT_ROLE()
Return value:CHAR
Function type:Information function
Function Description

The CURRENT_ROLE() function returns the name of the current permissions role.

This role determines the access rights of the authenticated user.

If there is no current role, MariaDB will return NULL. MySQL then returns NONE.

SQL Examples for the CURRENT_ROLE function

 1
 2
 3
 4
 5
 6
 7

select current_role();

set role 'myrole';

select current_role();

current_role()
varchar(80) BINARY
NULL
current_role()
varchar(80) BINARY
myrole
The examples were created with the MyWAY SQL manager: Download

How to use the CURRENT_ROLE() function in MySQL and MariaDB databases

In MySQL and MariaDB the CURRENT_ROLE() function can be used to return the name of the current privilege role.

In MySQL and MariaDB, roles are a way to manage and control user permissions. A set of permissions can be grouped in a role and assigned to multiple users. This is a easy way to manage permissions in databases. As such, permission roles provide a more organized and efficient way to manage user permissions, especially when multiple users require the same permissions.
CRC32CURDATECURRENT_DATECURRENT_ROLECURRENT_TIMECURRENT_TIMESTAMPCURRENT_USER

Further MySQL und MariaDB SQL Information functions

BENCHMARKBENCHMARK(Number, Expression)
More about BENCHMARK Function

BINLOG_GTID_POSBINLOG_GTID_POS()

CHARSETCHARSET(String)
More about CHARSET Function

COERCIBILITYCOERCIBILITY(String)
More about COERCIBILITY Function

COLLATIONCOLLATION(String)
More about COLLATION Function

CONNECTION_IDCONNECTION_ID()
More about CONNECTION_ID Function

CURRENT_USERCURRENT_USER()
More about CURRENT_USER Function

DATABASEDATABASE()
More about DATABASE Function

DECODE_HISTOGRAMDECODE_HISTOGRAM()

DEFAULTDEFAULT(Column)
More about DEFAULT Function

FOUND_ROWSFOUND_ROWS()
More about FOUND_ROWS Function

LAST_INSERT_IDLAST_INSERT_ID([Expression])
More about LAST_INSERT_ID Function

LAST_VALUELAST_VALUE(Expression [, Expression ...])
More about LAST_VALUE Function

ROWNUMROWNUM()

ROW_COUNTROW_COUNT()
More about ROW_COUNT Function

SCHEMASCHEMA()
More about SCHEMA Function

SESSION_USERSESSION_USER()
More about SESSION_USER Function

SYSTEM_USERSYSTEM_USER()
More about SYSTEM_USER Function

USERUSER()
More about USER Function

VERSIONVERSION()
More about VERSION Function

Numeric functionsString functionsRegular ExpressionsDate and Time functions
Comparison functionsEncryption & CompressionConversion functionsNULL functions
Aggregate functionsWindow functionsJSON functionsGeometric functions
Sequence functionsInformation functionsDynamic ColumnsMiscellaneous functions
More information about the CURRENT_ROLE SQL function: mysql.com and mariadb.com
Updated: 2023-09-17ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer