oracle创建表空间、用户、授权

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