userenv Etiketli Yazılar

Oracle – USERENV ile aktif oturuma ait bilgiler

USERENV ile aktif oturuma ait birtakım  bilgileri sorgulayabiliriz.

Oracle User:  sys_context(‘USERENV’, ‘CURRENT_USER’)

SELECT sys_context('USERENV', 'CURRENT_USER') FROM DUAL;

Oracle AUTHENTICATION TYPE: sys_context(‘USERENV’, ‘AUTHENTICATION_TYPE’)

SELECT sys_contextsys_context('USERENV', 'AUTHENTICATION_TYPE') FROM DUAL;

Oracle Network Protocol: sys_context(‘USERENV’, ‘NETWORK_PROTOCOL’)

SELECT sys_context('USERENV', 'NETWORK_PROTOCOL') FROM DUAL;

Oracle Client IP adresi: sys_context(‘USERENV’, ‘IP_ADDRESS’)

SELECT sys_context('USERENV', 'IP_ADDRESS') FROM DUAL;