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

1、创建表空间

create tablespace TEST 

logging

datafile ‘e:\app\administrator\oradata\orcl\TEST.dbf‘

size 100M

autoextend onnext 100M maxsize 4096Mextent management local;

2、创建用户并指定表空间

create use testuser identified by password

default tablespace TEST

temporary tablespace temp;

3、授权

grant connect to testuser;

grant dba to testuser;

grant role to testuser;