select
n.name, m.name,
decode(u.type#, 0, 'KERNEL', 1, 'PASSWORD', 'INVALID'),
decode(u.limit#,
0, 'DEFAULT',
2147483647, decode(u.resource#,
4, decode(u.type#,
1, 'NULL', 'UNLIMITED'),
'UNLIMITED'),
decode(u.resource#,
4, decode(u.type#, 1,
decode(nvl(SYS_CONTEXT('USERENV','CON_NAME'),
'CDB$ROOT'), 'CDB$ROOT', o.name,
decode(bitand(n.flags,1), 1,
'FROM ROOT', o.name)),
u.limit#),
decode(u.type#,
0, u.limit#,
decode(u.resource#,
1, trunc(u.limit#/86400, 4),
2, trunc(u.limit#/86400, 4),
5, trunc(u.limit#/86400, 4),
6, trunc(u.limit#/86400, 4),
u.limit#)))),
decode(bitand(n.flags, 1), 1, 'YES', 'NO')
from sys.profile$ u, sys.profname$ n, sys.resource_map m, sys.obj$ o,
sys.dual d
where u.resource# = m.resource#
and u.type#=m.type#
and o.obj# (+) = u.limit#
and n.profile# = u.profile#
SELECT
N.NAME
, M.NAME
,
DECODE(U.TYPE#
, 0
, 'KERNEL'
, 1
, 'PASSWORD'
, 'INVALID')
,
DECODE(U.LIMIT#
,
0
, 'DEFAULT'
,
2147483647
, DECODE(U.RESOURCE#
,
4
, DECODE(U.TYPE#
,
1
, 'NULL'
, 'UNLIMITED')
,
'UNLIMITED')
,
DECODE(U.RESOURCE#
,
4
, DECODE(U.TYPE#
, 1
,
DECODE(NVL(SYS_CONTEXT('USERENV'
, 'CON_NAME')
,
'CDB$ROOT')
, 'CDB$ROOT'
, O.NAME
,
DECODE(BITAND(N.FLAGS
, 1)
, 1
,
'FROM ROOT'
, O.NAME))
,
U.LIMIT#)
,
DECODE(U.TYPE#
,
0
, U.LIMIT#
,
DECODE(U.RESOURCE#
,
1
, TRUNC(U.LIMIT#/86400
, 4)
,
2
, TRUNC(U.LIMIT#/86400
, 4)
,
5
, TRUNC(U.LIMIT#/86400
, 4)
,
6
, TRUNC(U.LIMIT#/86400
, 4)
,
U.LIMIT#))))
,
DECODE(BITAND(N.FLAGS
, 1)
, 1
, 'YES'
, 'NO')
FROM SYS.PROFILE$ U
, SYS.PROFNAME$ N
, SYS.RESOURCE_MAP M
, SYS.OBJ$ O
,
SYS.DUAL D
WHERE U.RESOURCE# = M.RESOURCE#
AND U.TYPE#=M.TYPE#
AND O.OBJ# (+) = U.LIMIT#
AND N.PROFILE# = U.PROFILE#
|
|
|