CURRENT_ROLE() - Current Role of Logged-In User

Q

How to obtain the current role of the logged-in user using the CURRENT_ROLE() function?

✍: FYIcenter.com

A

CURRENT_ROLE() is a MySQL built-in function that returns the current role of the logged-in user. For example:

SELECT CURRENT_ROLE();
  -- +----------------+
  -- | CURRENT_ROLE() |
  -- +----------------+
  -- | NONE           |
  -- +----------------+

Reference information of the CURRENT_ROLE() function:

CURRENT_ROLE(): role
  Returns the current role of the logged-in user.

Arguments, return value and availability:
  role: Return value. The current role of the logged-in user.
  Available since MySQL 4.0.

⇒ CURRENT_USER() - Authentication Name of Current User

⇐ CONNECTION_ID() - Thread ID of Current Connection

⇑ MySQL Functions on System Information

⇑⇑ MySQL Function References

2024-07-15, 1435🔥, 0💬

CRC32() - Cyclic Redundancy Check 32-Bit
How to calculate the 32-bit CRC (Cyclic Redundancy Check) value using the CRC32() function? CRC32(str) is a MySQL built-in function that calculates the 32-bit CRC (Cyclic Redundancy Check) value of a given character string and returns it as an integer. For example: SELECT CRC32('MySQL'), HEX(CRC32('... 2024-07-15, 581🔥, 0💬

BENCHMARK() - Repeating Expression Evaluation
How to evaluate an expression repeatedly for benchmark testing using the BENCHMARK() function? BENCHMARK(count, exp) is a MySQL built-in function that evaluates an expression repeatedly for benchmark testing and returns 0. For example: SELECT BENCHMARK(1000000, AES_ENCRYPT('hello','goodbye') );-- +-... 2024-07-17, 579🔥, 2💬

💬 2024-07-17 Iqra Technology: This is a great overview of the `BENCHMARK()` function in MySQL! Your examples clearly illustrate how it can be used to evaluate...

MySQL Functions on System Information
Where to find reference information and tutorials on MySQL database functions on System Information? I want to know how to use DATABASE(), VERSION() and other functions. Here is a collection of reference information and tutorials on MySQL database functions on System Information compiled by FYIcente... 2024-07-15, 576🔥, 0💬

SLEEP() - Holding Statement Execution
How to hold the statement execution for some time using the SLEEP() function? SLEEP(sec) is a MySQL built-in function that holds the execution of the current statement for sec seconds. For example: SELECT SYSDATE(), SLEEP(2), SYSDATE(); -- +---------------------+------- ---+---------------------+-- ... 2023-12-19, 553🔥, 0💬

VERSION() - Version Number of MySQL Server
How to obtain the version number of the MySQL server using the VERSION() function? VERSION() is a MySQL built-in function that returns the version number of the MySQL server. For example: SELECT VERSION(); -- +-----------+ -- | VERSION() | -- +-----------+ -- | 8.0.17 | -- +-----------+ SELECT @@ver... 2025-01-07, 530🔥, 0💬

CONNECTION_ID() - Thread ID of Current Connection
How to obtain the connection ID of the current connection using the CONNECTION_ID() function? CONNECTION_ID() is a MySQL built-in function that returns the connection ID of the current connection. The connection ID is also referred as thread ID or process ID. For example: SELECT CONNECTION_ID(); -- ... 2024-07-15, 511🔥, 0💬

NAME_CONST() - PS Thread ID of Given Connect
How to provide a column name for a constant in a SELECT statement using the NAME_CONST() function? NAME_CONST(con) is a MySQL built-in function that provides a column name for a constant in a SELECT statement. For example: SELECT NAME_CONST('domain', 'dba.fyicenter.com'); -- +-------------------+ --... 2025-01-07, 435🔥, 0💬

SYSTEM_USER() - Synonym for USER()
What's the difference between SYSTEM_USER() and USER() functions? SYSTEM_USER() is a synonym for the USER() function. Related MySQL functions: USER() - Login Name of Current User SESSION_USER() - Synonym for USER() SYSTEM_USER() - Synonym for USER() CURRENT_USER() - Authentication Name of Current Us... 2025-01-07, 429🔥, 0💬

USER() - Login Name of Current User
How to obtain the login name of the current user using the USER() function? USER() is a MySQL built-in function that returns the login name of the current user. Login name is defined as the combination of user name and the client IP address where you logged in from. For example: SELECT USER(); -- +-... 2025-01-07, 420🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.