VIEW: SYS.KU$_TSQUOTA_VIEW

Source

View Text - Preformatted

select  '1','0',
          u.user#, u.name, t.name, q.ts#, q.maxblocks, t.blocksize, q.grantor#,
          'SYSTEM', q.blocks, q.priv1, q.priv2, q.priv3
  from    sys.user$ u, sys.tsq$ q, sys.ts$ t
  where   q.user# = u.user# AND
          q.ts# = t.ts# AND
          q.maxblocks != 0 AND
          t.online$ IN (1, 2, 4) AND
          bitand(t.flags,2048) = 0 AND
          (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
                OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, U.USER#
, U.NAME
, T.NAME
, Q.TS#
, Q.MAXBLOCKS
, T.BLOCKSIZE
, Q.GRANTOR#
, 'SYSTEM'
, Q.BLOCKS
, Q.PRIV1
, Q.PRIV2
, Q.PRIV3
FROM SYS.USER$ U
, SYS.TSQ$ Q
, SYS.TS$ T
WHERE Q.USER# = U.USER# AND Q.TS# = T.TS# AND Q.MAXBLOCKS != 0 AND T.ONLINE$ IN (1
, 2
, 4) AND BITAND(T.FLAGS
, 2048) = 0 AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))