首先常规的授权：CONNECT,RESOURCE,包含如下权限：
SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE IN (‘CONNECT’,‘RESOURCE’) ORDER BY 1,2;
CREATE SESSION
SET CONTAINER
CREATE CLUSTER
CREATE INDEXTYPE
CREATE OPERATOR
CREATE PROCEDURE
CREATE SEQUENCE
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
其他需要用到的整合为如下授权语句，可考虑整理成role授权：
GRANT CONNECT,RESOURCE,CREATE JOB,CREATE VIEW,CREATE MATERIALIZED VIEW,CREATE SYNONYM,CREATE ROLE,CREATE RULE,CREATE PUBLIC DATABASE LINK,CREATE DATABASE LINK TO TEST_USER;