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 - Oracle Compatibility:
-- Get the current user SELECT USER();
For more information, see Oracle to MariaDB Migration - Oracle Compatibility Mode.