VIEW: SYS.DBA_PROFILES

Source

View Text - Preformatted

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#

View Text - HTML Formatted

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#