oracle 用户创建

来源：互联网发布：全本网络下载下载编辑：程序博客网时间：2024/05/29 04:08

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;

0 0