DBA Data[Home] [Help]

VIEW: SYS.KU$_PROFILE_ATTR_VIEW

Source

View Text - Preformatted

select  p.profile#,
          p.resource#,
          r.name,
          p.type#,
          p.limit#
  from sys.resource_map r, sys.profile$ p
  where p.resource# = r.resource# and p.type# = r.type#
View Text - HTML Formatted

SELECT P.PROFILE#
, P.RESOURCE#
, R.NAME
, P.TYPE#
, P.LIMIT#
FROM SYS.RESOURCE_MAP R
, SYS.PROFILE$ P
WHERE P.RESOURCE# = R.RESOURCE#
AND P.TYPE# = R.TYPE#