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, 241🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...