Tuesday, April 21, 2009

sys_context - userenv

SELECT sys_context('USERENV', 'ACTION') action,
sys_context('USERENV', 'AUDITED_CURSORID') audited_cursorid,
sys_context('USERENV', 'AUTHENTICATED_IDENTITY') authenticated_identity,
sys_context('USERENV', 'AUTHENTICATION_DATA') authentication_data,
sys_context('USERENV', 'AUTHENTICATION_METHOD') authentication_method,
sys_context('USERENV', 'BG_JOB_ID') bg_job_id,
sys_context('USERENV', 'CLIENT_IDENTIFIER') client_identifier,
sys_context('USERENV', 'CLIENT_INFO') client_info,
sys_context('USERENV', 'CURRENT_BIND') current_bind,
sys_context('USERENV', 'CURRENT_SCHEMA') "current_schema",
sys_context('USERENV', 'CURRENT_SCHEMAID') current_schemaid,
sys_context('USERENV', 'CURRENT_SQL') current_sql,
sys_context('USERENV', 'CURRENT_SQL_LENGTH') current_sql_length,
sys_context('USERENV', 'DB_DOMAIN') db_domain,
sys_context('USERENV', 'DB_NAME') db_name,
sys_context('USERENV', 'DB_UNIQUE_NAME') db_unique_name,
sys_context('USERENV', 'ENTRYID') entryid,
sys_context('USERENV', 'ENTERPRISE_IDENTITY') enterprise_identity,
sys_context('USERENV', 'FG_JOB_ID') fg_job_id,
sys_context('USERENV', 'GLOBAL_CONTEXT_MEMORY') global_context_memory,
sys_context('USERENV', 'GLOBAL_UID') global_uid,
sys_context('USERENV', 'HOST') host,
sys_context('USERENV', 'IDENTIFICATION_TYPE') identification_type,
sys_context('USERENV', 'INSTANCE') "instance",
sys_context('USERENV', 'INSTANCE_NAME') instance_name,
sys_context('USERENV', 'IP_ADDRESS') ip_address,
sys_context('USERENV', 'ISDBA') isdba,
sys_context('USERENV', 'LANG') lang,
sys_context('USERENV', 'LANGUAGE') "language",
sys_context('USERENV', 'MODULE') "module",
sys_context('USERENV', 'NETWORK_PROTOCOL') network_protocol,
sys_context('USERENV', 'NLS_CALENDAR') nls_calendar,
sys_context('USERENV', 'NLS_CURRENCY') nls_currency,
sys_context('USERENV', 'NLS_DATE_FORMAT') nls_date_format,
sys_context('USERENV', 'NLS_DATE_LANGUAGE') nls_date_language,
sys_context('USERENV', 'NLS_SORT') nls_sort,
sys_context('USERENV', 'NLS_TERRITORY') nls_territory,
sys_context('USERENV', 'OS_USER') os_user,
sys_context('USERENV', 'POLICY_INVOKER') policy_invoker,
sys_context('USERENV', 'PROXY_ENTERPRISE_IDENTITY') proxy_enterprise_identity,
-- sys_context('USERENV', 'PROXY_GLOBAL_UID') proxy_global_uid,
sys_context('USERENV', 'PROXY_USER') proxy_user,
sys_context('USERENV', 'PROXY_USERID') proxy_userid,
sys_context('USERENV', 'SERVER_HOST') server_host,
sys_context('USERENV', 'SERVICE_NAME') service_name,
sys_context('USERENV', 'SESSION_USER') session_user,
sys_context('USERENV', 'SESSION_USERID') session_userid,
sys_context('USERENV', 'SESSIONID') sessionid,
sys_context('USERENV', 'SID') sid,
sys_context('USERENV', 'STATEMENTID') statementid,
sys_context('USERENV', 'TERMINAL') terminal
FROM dual;