Collections:
CURRENT_ROLE() - Current Role of Logged-In User
How to obtain the current role of the logged-in user using the CURRENT_ROLE() function?
✍: FYIcenter.com
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
2023-12-19, 235🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...