select name, decode(password, null,
decode(spare4, null, 'NO',
decode(REGEXP_INSTR(spare4, '[ST]:'), 0, 'NO',
'YES')),
'EXTERNAL', 'EXTERNAL',
'GLOBAL', 'GLOBAL',
'YES'),
decode(password, null,
decode(spare4, null, 'NONE',
decode(REGEXP_INSTR(spare4, '[ST]:'), 0, 'NONE',
'PASSWORD')),
'EXTERNAL', 'EXTERNAL',
'GLOBAL', 'GLOBAL',
'APPLICATION', 'APPLICATION',
'PASSWORD'),
decode(bitand(spare1, 128), 128, 'YES', 'NO'),
decode(bitand(spare1, 256), 256, 'Y', 'N')
from user$
where type# = 0 and name not in ('PUBLIC', '_NEXT_USER')
SELECT NAME
, DECODE(PASSWORD
, NULL
,
DECODE(SPARE4
, NULL
, 'NO'
,
DECODE(REGEXP_INSTR(SPARE4
, '[ST]:')
, 0
, 'NO'
,
'YES'))
,
'EXTERNAL'
, 'EXTERNAL'
,
'GLOBAL'
, 'GLOBAL'
,
'YES')
,
DECODE(PASSWORD
, NULL
,
DECODE(SPARE4
, NULL
, 'NONE'
,
DECODE(REGEXP_INSTR(SPARE4
, '[ST]:')
, 0
, 'NONE'
,
'PASSWORD'))
,
'EXTERNAL'
, 'EXTERNAL'
,
'GLOBAL'
, 'GLOBAL'
,
'APPLICATION'
, 'APPLICATION'
,
'PASSWORD')
,
DECODE(BITAND(SPARE1
, 128)
, 128
, 'YES'
, 'NO')
,
DECODE(BITAND(SPARE1
, 256)
, 256
, 'Y'
, 'N')
FROM USER$
WHERE TYPE# = 0
AND NAME NOT IN ('PUBLIC'
, '_NEXT_USER')
|
|
|