Oracle® TimesTen In-Memory Database SQL Reference Release 11.2.1 Part Number E13070-04 |
|
|
View PDF |
TimesTen supports these USER functions:
Each of these functions returns the name of the user that is currently connected to the TimesTen database.
Returns the name of the TimesTen user currently connected to the data store.
SQL syntax
CURRENT_USER
Parameters
CURRENT_USER has no parameters.
Examples
To return the name of the user who is currently connected to the data store:
SELECT CURRENT_USER FROM dual;
Returns the name of the TimesTen user who is currently connected to the data store.
SQL syntax
USER
Parameters
USER has no parameters.
Examples
To return the name of the user who is currently connected to the data store:
SELECT USER FROM dual;
Returns the name of the TimesTen user currently connected to the data store.
SQL syntax
SESSION_USER
Parameters
SESSION_USER has no parameters.
Examples
To return the name of the session user:
SELECT SESSION_USER FROM dual;
Returns the name of the current data store user as identified by the operating system.
SQL syntax
SYSTEM_USER
Parameters
SYSTEM_USER has no parameters.
Examples
To return the name of the operating system user:
SELECT SYSTEM_USER FROM dual;