oracle 用户创建

create user test01 identified by 123456; 

alter user test01 default tablespace TBSP_test01 quota unlimited on TBSP_test01;

  alter user test01 quota unlimited on TBSP_test01_IDX; 

alter user test01 temporary tablespace TBSP_test01_TMP;

grant create trigger to test01; 

grant create session to test01; 

grant create sequence to test01;

grant create synonym to test01; 

grant create table to test01;

grant create view to test01; 

grant create procedure to test01; 

grant alter session to test01; 

grant create job to test01 ; 

grant execute on ctxsys.ctx_ddl to test01;  

--如果需要DBA权限 

grant dba to test01;