GV$PWFILE_USERS
select inst_id, -- INST_ID NUMBER username, -- USERNAME VARCHAR2(30) decode -- SYSDBA VARCHAR2(5) (sysdba, 1, 'TRUE', 'FALSE'), decode -- SYSOPER VARCHAR2(5) (sysoper, 1, 'TRUE', 'FALSE') from x$kzsrt where valid=1 and username != 'INTERNAL'

home |  up  |  mailbox