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

posted @ 2017-12-29 15:07  但行好事-莫问前程  阅读(290)  评论(0编辑  收藏