oracle创建表空间及其用户并分配权限

#首先用dba打开数据库连接

system/manager as sysdba

#新建运维临时表空间

create temporary tablespace jxmglxt_temp

tempfile'C:\app\Administrator\oradata\orcl\jxmglxt_temp.dbf'

size 32m

autoextend on

next 32m maxsize 2048m

extent management local;

#建立运维表空间

create tablespace jxmglxt

logging

datafile'C:\app\Administrator\oradata\orcl\jxmglxt.dbf'

size 32m

autoextend on

next 32m maxsize 2048m

extent management local;

#新建运维用户，给与此表空间

create user jxmglxt identified by jxmglxt

default tablespace jxmglxt

temporary tablespace jxmglxt_temp;

#给此运维用户授予此权限

grant connect,resource,dba to jxmglxt