VIEW: SYS.KU$_PROFILE_VIEW

Source

View Text - Preformatted

select '1','0',
        n.profile#,
        n.name,
        (select distinct o.name
            from    sys.obj$ o, sys.ku$_profile_attr_view p
            where   o.type# = 8 AND
                    o.owner# = 0 AND
                    o.obj# = p.limit_num and
                    p.profile_id = n.profile# and
                    p.resource_num =4 and    -- res# 4, type# 1 =
                    p.type_num =1 ),         -- PASSWORD_VERIFY_FUNCTION
        cast(multiset (select * from ku$_profile_attr_view pl
            where pl.profile_id = n.profile# ) as ku$_profile_list_t
        )
  from sys.profname$ n
  where (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
        OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, N.PROFILE#
, N.NAME
, (SELECT DISTINCT O.NAME
FROM SYS.OBJ$ O
, SYS.KU$_PROFILE_ATTR_VIEW P
WHERE O.TYPE# = 8 AND O.OWNER# = 0 AND O.OBJ# = P.LIMIT_NUM AND P.PROFILE_ID = N.PROFILE# AND P.RESOURCE_NUM =4
AND -- RES# 4
, TYPE# 1 = P.TYPE_NUM =1 )
, -- PASSWORD_VERIFY_FUNCTION CAST(MULTISET (SELECT *
FROM KU$_PROFILE_ATTR_VIEW PL
WHERE PL.PROFILE_ID = N.PROFILE# ) AS KU$_PROFILE_LIST_T )
FROM SYS.PROFNAME$ N
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))