CURRENT_ROLE
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.0.5
Roles were introduced in MariaDB 10.0.5.
Syntax
CURRENT_ROLE, CURRENT_ROLE()
Description
Returns the current role name. This determines your access privileges. The return value is a string in the utf8 character set.
If there is no current role, NULL is returned.
The output of SELECT CURRENT_ROLE
is equivalent to the contents of the ENABLED_ROLES
Information Schema table.
USER()
returns the combination of user and host used to login. CURRENT_USER()
returns the account used to determine current connetion's privileges.
Examples
SELECT CURRENT_ROLE; +--------------+ | CURRENT_ROLE | +--------------+ | NULL | +--------------+ SET ROLE staff; SELECT CURRENT_ROLE; +--------------+ | CURRENT_ROLE | +--------------+ | staff | +--------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.