VIEW: SYS.EXU8USR

Source

View Text - Preformatted

SELECT  u.name, u.user#, DECODE(u.password, 'N', '', u.password),
                DECODE(u.defrole, 0, 'N', 1, 'A', 2, 'L', 3, 'E', 'X'),
                ts1.name, DECODE(BITAND(ts2.flags,2048),2048,'SYSTEM',ts2.name),
                u.resource$, p.name, u.astatus,
                u.ext_username
        FROM    sys.user$ u, sys.ts$ ts1, sys.ts$ ts2, sys.profname$ p
        WHERE   u.datats# = ts1.ts# AND
                u.tempts# = ts2.ts# AND
                u.type# = 1 AND
                u.resource$ = p.profile# AND
                u.name NOT IN ( 'ORDSYS',  'MDSYS', 'CTXSYS', 'ORDPLUGINS',
                                'LBACSYS', 'XDB',   'SI_INFORMTN_SCHEMA',
                                'DIP',  'DBSNMP', 'EXFSYS', 'WMSYS',
                                'ORACLE_OCM', 'ANONYMOUS', 'XS$NULL',
                                'APPQOSSYS', 'OJVMSYS', 'SYSBACKUP', 'SYSDG',
                                'SYSKM', 'DVSYS', 'DVF', 'ORDDATA',
                                'GSMADMIN_INTERNAL', 'GSMUSER', 'GSMCATUSER',
                                'LOGSTDBY_ADMINISTRATOR','OLAPSYS',
                                'FLOWS_FILES', 'APEX_040200')

View Text - HTML Formatted

SELECT U.NAME
, U.USER#
, DECODE(U.PASSWORD
, 'N'
, ''
, U.PASSWORD)
, DECODE(U.DEFROLE
, 0
, 'N'
, 1
, 'A'
, 2
, 'L'
, 3
, 'E'
, 'X')
, TS1.NAME
, DECODE(BITAND(TS2.FLAGS
, 2048)
, 2048
, 'SYSTEM'
, TS2.NAME)
, U.RESOURCE$
, P.NAME
, U.ASTATUS
, U.EXT_USERNAME
FROM SYS.USER$ U
, SYS.TS$ TS1
, SYS.TS$ TS2
, SYS.PROFNAME$ P
WHERE U.DATATS# = TS1.TS# AND U.TEMPTS# = TS2.TS# AND U.TYPE# = 1 AND U.RESOURCE$ = P.PROFILE# AND U.NAME NOT IN ( 'ORDSYS'
, 'MDSYS'
, 'CTXSYS'
, 'ORDPLUGINS'
, 'LBACSYS'
, 'XDB'
, 'SI_INFORMTN_SCHEMA'
, 'DIP'
, 'DBSNMP'
, 'EXFSYS'
, 'WMSYS'
, 'ORACLE_OCM'
, 'ANONYMOUS'
, 'XS$NULL'
, 'APPQOSSYS'
, 'OJVMSYS'
, 'SYSBACKUP'
, 'SYSDG'
, 'SYSKM'
, 'DVSYS'
, 'DVF'
, 'ORDDATA'
, 'GSMADMIN_INTERNAL'
, 'GSMUSER'
, 'GSMCATUSER'
, 'LOGSTDBY_ADMINISTRATOR'
, 'OLAPSYS'
, 'FLOWS_FILES'
, 'APEX_040200')