Oracle 접속을 위한 Catalog 접근 권한

-- DataStage PX Oracle Settging
GRANT select ON sys.gv_$instance TO public;
GRANT select ON sys.v_$cache TO public;
CREATE ROLE DSXE;
GRANT SELECT on sys.dba_extents to DSXE;
GRANT SELECT on sys.dba_data_files to DSXE;
GRANT SELECT on sys.dba_tab_partitions to DSXE;
GRANT SELECT on sys.dba_tab_subpartitions to DSXE;
GRANT SELECT on sys.dba_objects to DSXE;
GRANT SELECT on sys.all_part_indexes to DSXE;
GRANT SELECT on sys.all_part_tables to DSXE;
GRANT SELECT on sys.all_indexes to DSXE;

GRANT DSXE to <oracle userid>;