VIEW: SYS.KU$_DEPTYPES_VIEW

Source

View Text - Preformatted

select b.typeobjno, b.typename, b.typeownerno, b.typeowner, b.typeobjflags,
        b.dobjno, b.dname
 from ku$_deptypes_base_view b
 where (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (b.typeownerno, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT B.TYPEOBJNO
, B.TYPENAME
, B.TYPEOWNERNO
, B.TYPEOWNER
, B.TYPEOBJFLAGS
, B.DOBJNO
, B.DNAME
FROM KU$_DEPTYPES_BASE_VIEW B
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (B.TYPEOWNERNO
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))