select o.obj#,u.name
from obj$ o, user$ u, con$ c, cdef$ cd
where o.owner#=u.user#
and cd.obj# = o.obj#
and c.con# = cd.con#
and cd.type# = 4 -- referential constraint
and (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner#,0) OR
EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT O.OBJ#
, U.NAME
FROM OBJ$ O
, USER$ U
, CON$ C
, CDEF$ CD
WHERE O.OWNER#=U.USER#
AND CD.OBJ# = O.OBJ#
AND C.CON# = CD.CON#
AND CD.TYPE# = 4 -- REFERENTIAL CONSTRAINT
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR
EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|