SELECT t.cols, t.rowcnt, t.avgrln, u.name, o.name
FROM SYS.OBJ$ O, SYS.TAB$ T, SYS.USER$ U
WHERE t.obj# = o.obj# AND
o.owner# = u.user# AND
(UID IN (0, o.owner#) OR
EXISTS (
SELECT role
FROM sys.session_roles
WHERE role = 'SELECT_CATALOG_ROLE'))
SELECT T.COLS
, T.ROWCNT
, T.AVGRLN
, U.NAME
, O.NAME
FROM SYS.OBJ$ O
, SYS.TAB$ T
, SYS.USER$ U
WHERE T.OBJ# = O.OBJ# AND
O.OWNER# = U.USER# AND
(UID IN (0
, O.OWNER#) OR
EXISTS (
SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE'))
|
|
|