Buscar en este blog

miércoles, 9 de abril de 2008

ORACLE. Información session del usuario


-- información usuarios

select v.sid, v.serial#, v.username, v.program
from user_users u, v$session v
where v.user# = u.user_id

select *
from user_users u, v$session v
where v.user# = u.user_id

-- session del usuario

select userenv('sessionid')
from dual;

--- información del usuario apartir de la session
select *
from user_users u, v$session v
where v.user# = u.user_id
and audsid = userenv('sessionid')

select *
from user_users u, v$session v
where v.user# = u.user_id
order by LOGON_TIME DESC

select SCHEMANAME, OSUSER, MACHINE, TERMINAL, PROGRAM, MODULE, LOGON_TIME
from user_users u, v$session v
where v.user# = u.user_id
order by LOGON_TIME DESC

No hay comentarios: