Access Verification Query

From DB Optimizer
Jump to: navigation, search

Oracle Verificaiton Query

SELECT 1 FROM dual WHERE

( SELECT 1 FROM dual WHERE USER = 'SYS' ) IS NOT NULL

OR

( SELECT 1 FROM session_roles WHERE role ='SELECT_CATALOG_ROLE' ) IS NOT NULL