oracle快速创建可用用户

执行语句

create user utaptest identified by utaptest;
create tablespace utaptestspace datafile 'd:data.dbf' size 100m;
alter user utaptest default tablespace utaptestspace;
grant create session,create table,unlimited tablespace to utaptest;
grant create session, create table ,unlimited tablespace to utaptest;
grant create sequence to utaptest;
grant resource,connect to utaptest;
grant execute any procedure to utaptest;
GRANT DEBUG CONNECT SESSION TO utaptest;

ok

原文地址:https://www.cnblogs.com/garfieldcgf/p/8144594.html