Check the DB User, OS User, IP address, hostname, service name from session in Oracle
Check the OS User from session
--- From sys_context
SELECT SYS_CONTEXT ('USERENV', 'OS_USER') FROM DUAL;
SYS_CONTEXT('USERENV','OS_USER')
--------------------------------
Oracle
Check the current user session
SQL> conn test@xepdb1
Enter password:
Connected.
SQL>
SQL> SELECT SYS_CONTEXT ('USERENV','SESSION_USER') FROM DUAL;
SYS_CONTEXT('USERENV','SESSION_USER')
-------------------------------------
TEST
Check service name which Session connected
SQL> SELECT SYS_CONTEXT ('USERENV','SERVICE_NAME') FROM DUAL;
SYS_CONTEXT('USERENV','SERVICE_NAME')
-------------------------------------
xepdb1
Get the hostname from SQLPLUS
SQL> SELECT SYS_CONTEXT ('USERENV','SERVER_HOST') FROM DUAL;
SYS_CONTEXT('USERENV','SERVER_HOST')
-------------------------------------
Hostname1
Get the IP ADDRESS from session connected
SELECT SYS_CONTEXT ('USERENV','IP_ADDRESS') FROM DUAL;
SYS_CONTEXT('USERENV','IP_ADDRESS')
-----------------------------------
10.10.238.210