1.增加 username 对应的表空间100G
set ORACLE_SID +ASM实例
asmcmd
lsdg(察看 DISKGROUPX 是否有100G空间)
如果有:
create bigfile tablespace NAME_TS2 datafile '+DISKGROUPX' size 100G;
2.创建用户 username
create user username identified by password default tablespace NAME_TS2;
3.赋权限
grant connect to username;
grant select any dictionary to username;
grant create any table to username;
grant unlimited tablespace to username;
grant create session to username;
grant unlimited tablespace to username;
grant create table to username;
grant create any table to username;
grant select any table to username;
grant create any synonym to username;
grant create view to username;
grant create sequence to username;
grant create procedure to username;
grant create any procedure to username;
grant execute any procedure to username;
grant create trigger to username;
grant create type to username;
grant create operator to username;
grant create indextype to username;
grant select any dictionary to username;
grant debug any procedure to username;
OK