VIEW: DVSYS.DBA_DV_AUTH

Source

View Text - Preformatted

SELECT
    grant_type
  , u1.name
  , u2.name
  , da.object_name
  , da.object_type
FROM dvsys.dv_auth$ da, sys.user$ u1, sys.user$ u2
WHERE da.grantee_id = u1.user# and
      da.object_owner_id = u2.user#
UNION
SELECT
    grant_type
  , u1.name
  , '%'
  , object_name
  , object_type
FROM dvsys.dv_auth$ da, sys.user$ u1
WHERE da.grantee_id = u1.user# and
      da.object_owner_id = 2147483636
UNION
SELECT
    grant_type
  , '%'
  , u2.name
  , object_name
  , object_type
FROM dvsys.dv_auth$ da, sys.user$ u2
WHERE da.grantee_id = 2147483636 and
      da.object_owner_id = u2.user#
UNION
SELECT
    grant_type
  , '%'
  , '%'
  , object_name
  , object_type
FROM dvsys.dv_auth$ da
WHERE da.grantee_id = 2147483636 and
      da.object_owner_id = 2147483636

View Text - HTML Formatted

SELECT GRANT_TYPE
, U1.NAME
, U2.NAME
, DA.OBJECT_NAME
, DA.OBJECT_TYPE FROM DVSYS.DV_AUTH$ DA
, SYS.USER$ U1
, SYS.USER$ U2 WHERE DA.GRANTEE_ID = U1.USER# AND DA.OBJECT_OWNER_ID = U2.USER# UNION SELECT GRANT_TYPE
, U1.NAME
, '%'
, OBJECT_NAME
, OBJECT_TYPE FROM DVSYS.DV_AUTH$ DA
, SYS.USER$ U1 WHERE DA.GRANTEE_ID = U1.USER# AND DA.OBJECT_OWNER_ID = 2147483636 UNION SELECT GRANT_TYPE
, '%'
, U2.NAME
, OBJECT_NAME
, OBJECT_TYPE FROM DVSYS.DV_AUTH$ DA
, SYS.USER$ U2 WHERE DA.GRANTEE_ID = 2147483636 AND DA.OBJECT_OWNER_ID = U2.USER# UNION SELECT GRANT_TYPE
, '%'
, '%'
, OBJECT_NAME
, OBJECT_TYPE FROM DVSYS.DV_AUTH$ DA WHERE DA.GRANTEE_ID = 2147483636 AND DA.OBJECT_OWNER_ID = 2147483636