select distinct p.package, p.schema
FROM sys.exppkgobj$ p
WHERE (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0 OR
SYS_CONTEXT('USERENV','SESSION_USER') = p.schema OR
EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT DISTINCT P.PACKAGE
, P.SCHEMA
FROM SYS.EXPPKGOBJ$ P
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR
SYS_CONTEXT('USERENV'
, 'SESSION_USER') = P.SCHEMA OR
EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|