select u.name pre_owner
,pre_name pre_name
,cla_name pre_class
,obj_name pre_object
from dr$preference
,dr$object
,dr$class
,sys.user$ u
where pre_obj_id = obj_id
and pre_cla_id = obj_cla_id
and obj_cla_id = cla_id
and obj_system = 'N'
and cla_system = 'N'
and pre_owner# = u.user#
SELECT U.NAME PRE_OWNER
, PRE_NAME PRE_NAME
, CLA_NAME PRE_CLASS
, OBJ_NAME PRE_OBJECT
FROM DR$PREFERENCE
, DR$OBJECT
, DR$CLASS
, SYS.USER$ U
WHERE PRE_OBJ_ID = OBJ_ID
AND PRE_CLA_ID = OBJ_CLA_ID
AND OBJ_CLA_ID = CLA_ID
AND OBJ_SYSTEM = 'N'
AND CLA_SYSTEM = 'N'
AND PRE_OWNER# = U.USER#
|
|
|