Dba / Users -
who.sql - Liste des utilisateurs OS/Oracle
ttitle 'Liste des utilisateurs OS/Oracle' SELECT nvl(S.OSUSER,S.type) OS_Usercode, S.USERNAME Oracle_Usercode, S.sid Oracle_SID, S.process F_Ground, P.spid B_Ground FROM V$SESSION S, V$PROCESS P WHERE nvl(upper(S.OSUSER),'?') like nvl(upper('&OS_User'),'%') And nvl(upper(S.Username),'?') like nvl(upper('&Oracle_User'),'%') And s.paddr = p.addr order by s.sid; ttitle off Doc Type: DBA | SubType: | Cible: Users | Desc: Liste des utilisateurs OS/Oracle | who.sql #