1.创建表空间

create tablespace local datafile 'C:\orcl\local.dbf' size 50M autoextend on next 50m maxsize 2048m;

2.创建用户

create user localuser identified by 111111 default tablespace local;

3.授权

grant connect,resource,dba to local;

撤销授权

revoke dba from local

 

posted on 2018-03-21 15:24  梓木的稻稻  阅读(145)  评论(0)    收藏  举报