赋予权限
grant “PUBLIC”,“SOI” to “TEST1”;
grant CREATE VIEW,CREATE PROCEDURE,CREATE SEQUENCE,CREATE TRIGGER,CREATE INDEX,CREATE CONTEXT INDEX,CREATE REPLICATE,CREATE PACKAGE,CREATE SYNONYM,CREATE PUBLIC SYNONYM,CREATE SESSION to “TEST1”;
grant EXECUTE on “TEST1”.“DRS_$DDL_SQL_PROC” to “TEST1”;
grant create MATERIALIZED VIEW TO TEST1;

赋予表的查询权限
grant SELECT on “TEST12”.“TABLE_2” to “DMDRS”;
grant SELECT FOR DUMP on “TEST12”.“TABLE_2” to “DMDRS”;
grant SELECT on “TEST12”.“TABLE_1” to “DMDRS”;
grant SELECT FOR DUMP on “TEST12”.“TABLE_1” to “DMDRS”;
grant SELECT on “TEST12”.“TABLE_4” to “DMDRS”;
grant SELECT FOR DUMP on “TEST12”.“TABLE_4” to “DMDRS”;
grant SELECT on “TEST12”.“TABLE_3” to “DMDRS”;
grant SELECT FOR DUMP on “TEST12”.“TABLE_3” to “DMDRS”;