반응형

/********************************************************************************************
-- Title : [10g] 현재 접속중인 세션 정보 출력 뷰
-- Key word :
********************************************************************************************/

create or replace view sys.sp_session0
as
    select 'SID' "NAME", sys_context('USERENV','SID') "VALUE" from dual union all
    select 'SESSIONID', sys_context('USERENV','SESSIONID') from dual union all
    select 'SESSION_USER', sys_context('USERENV','SESSION_USER') from dual union all
    select 'SESSION_USERID', sys_context('USERENV','SESSION_USERID') from dual union all
    select 'CURRENT_USER', sys_context('USERENV','CURRENT_USER') from dual union all
    select 'CURRENT_USERID', sys_context('USERENV','CURRENT_USERID') from dual union all
    select 'HOST', sys_context('USERENV','HOST') from dual union all
    select 'TERMINAL', sys_context('USERENV','TERMINAL') from dual;
-- select * from sys.sp_session0;

grant select on sp_session0 to public;

반응형

+ Recent posts