select '1','0',
null, ts.ts#, NULL,
'DBMS_PLUGTS', 'SYS', 0, 101, 0,
ts.name, ts.ts#, null, null, null, null, null
FROM sys.ts$ ts
where (SYS_CONTEXT('USERENV','CURRENT_USERID')=0
OR EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT '1'
, '0'
,
NULL
, TS.TS#
, NULL
,
'DBMS_PLUGTS'
, 'SYS'
, 0
, 101
, 0
,
TS.NAME
, TS.TS#
, NULL
, NULL
, NULL
, NULL
, NULL
FROM SYS.TS$ TS
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')=0
OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|