select permettant de connaitre les utilisateurs connectés grâce aux tables système
-- liste des utilisateurs connecté
SELECT u.name , c.sid, c.username, c.status, c.osuser, c.process, c.machine, c.terminal, c.program, c.logon_time
FROM v$session c,sys.USER$ u
WHERE u.USER# = c.USER#
AND u.name NOT IN ('SYS') ;
SELECT u.name , c.sid, c.username, c.status, c.osuser, c.process, c.machine, c.terminal, c.program, c.logon_time
FROM v$session c,sys.USER$ u
WHERE u.USER# = c.USER#
AND u.name NOT IN ('SYS') ;