In Oracle, the USER function returns the name of the session user. In MariaDB, you can use the USER() function.
Oracle:
-- Get the current user SELECT USER FROM dual;
MariaDB:
-- Get the current user SELECT USER();
For more information, see Oracle to MariaDB Migration.