create tablespace hyman_tablespace datafile 'G:\app\hyman\oradata\hyman_dev\hyman_dev.dbf' size 1000M autoextend on next 100M;

create user hyman identified by 111111 default tablespace hyman_tablespace ;

GRANT
　　CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
　　ALTER ANY TABLE, ALTER ANY PROCEDURE,
　　DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
　　SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE,
SELECT ANY SEQUENCE, CREATE ANY SEQUENCE,DROP ANY SEQUENCE，create trigger
TO DW_TEST;

--上面是一些基本權(quán)限，下面配置可以查看執(zhí)行計(jì)劃的權(quán)限：
grant select on v_statname to hyman;
grant select on v_sql_plan to hyman;
grant select on v_sql to hyman;