SQL CURRENT_USER Function

SQL CURRENT_USER

The SQL CURRENT_USER function returns the name of the database user executing the query. It is often used to determine the privileges and roles of the currently connected user.

In this tutorial, we will explore the CURRENT_USER function, its syntax, and practical examples demonstrating its usage in SQL.

---

Syntax of SQL CURRENT_USER

The basic syntax of the CURRENT_USER function is:

SELECT CURRENT_USER;

Alternatively, in some SQL databases like MySQL, you can also use:

SELECT CURRENT_USER();

Explanation:

• The function retrieves the user name associated with the current session.
• It may be useful for checking the privileges of the user executing queries.

---

Step-by-Step Examples Using SQL CURRENT_USER

1 Retrieving the Current User

To check the currently logged-in user in MySQL, execute:

SELECT CURRENT_USER();

Example Output: