select OWNER, TABLE_NAME, TABLE_TYPE, COMMENTS, ORIGIN_CON_ID
from INT$DBA_TAB_COMMENTS
where (OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')
or
OBJ_ID(OWNER, TABLE_NAME, OBJECT_TYPE#, OBJECT_ID)
in ( select obj#
from sys.objauth$
where grantee# in ( select kzsrorol
from x$kzsro
)
)
or /* user has system privileges */
exists (select null from v$enabledprivs
where priv_number in (-45 /* LOCK ANY TABLE */,
-47 /* SELECT ANY TABLE */,
-397/* READ ANY TABLE */,
-48 /* INSERT ANY TABLE */,
-49 /* UPDATE ANY TABLE */,
-50 /* DELETE ANY TABLE */)
)
)
SELECT OWNER
, TABLE_NAME
, TABLE_TYPE
, COMMENTS
, ORIGIN_CON_ID
FROM INT$DBA_TAB_COMMENTS
WHERE (OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')
OR
OBJ_ID(OWNER
, TABLE_NAME
, OBJECT_TYPE#
, OBJECT_ID)
IN ( SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN ( SELECT KZSROROL
FROM X$KZSRO
)
)
OR /* USER HAS SYSTEM PRIVILEGES */
EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-45 /* LOCK ANY TABLE */
,
-47 /* SELECT ANY TABLE */
,
-397/* READ ANY TABLE */
,
-48 /* INSERT ANY TABLE */
,
-49 /* UPDATE ANY TABLE */
,
-50 /* DELETE ANY TABLE */)
)
)
|
|
|