登录sysdba,执行以下操作
grant select on V_$session to myuser;
grant select on V_$sesstat to myuser;
grant select on V_$statname to myuser;
grant create session to myuser;
grant resource,connect to myuser;
grant unlimited tablespace to myuser;
grant create tablespace to myuser;
grant alter tablespace to myuser;
grant drop tablespace to myuser;
grant manage tablespace to myuser;
grant create table to myuser;
grant create view to myuser;
grant create trigger to myuser;
grant create procedure to myuser;
grant create sequence to myuser;
grant create rollback segment to myuser;
grant alter rollback segment to myuser;
grant drop rollback segment to myuser;
grant create synonym to myuser;
grant create public synonym to myuser;
grant drop public synonym to myuser;