VIEW: SYS.KU$_TRIG_EXISTS_VIEW

Source

View Text - Preformatted

select t.obj#,t.baseobject,u.name
 from trigger$ t, obj$ o, user$ u
 where o.obj# = t.obj#
 and o.owner#=u.user#
 and  (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner#,0) OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT T.OBJ#
, T.BASEOBJECT
, U.NAME
FROM TRIGGER$ T
, OBJ$ O
, USER$ U
WHERE O.OBJ# = T.OBJ#
AND O.OWNER#=U.USER#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))