oracle 创建表空间分配,Oracle创建表空间和用户并分配权限

表空间名称：TableSpaceA

临时表空间：TEMP

用户名称：UserA

用户密码：123456

表空间路径：D:\ORACLE\ORADATA

--1.创建表空间

CREATE TABLESPACE "TableSpaceA"

LOGGING

DATAFILE 'D:\ORACLE\ORADATA\TableSpaceName.ora' SIZE 100M

AUTOEXTEND

ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO ;

--2.创建用户

CREATE USER "UserA" PROFILE "DEFAULT"

IDENTIFIED BY "123456" DEFAULT TABLESPACE "TableSpaceA"

TEMPORARY TABLESPACE "TEMP"

ACCOUNT UNLOCK;

--3.用户授权

GRANT "CONNECT" TO "UserA" WITH ADMIN OPTION;

GRANT "DBA" TO "UserA" WITH ADMIN OPTION;

GRANT "RESOURCE" TO "UserA" WITH ADMIN OPTION;

标签：OPTION,GRANT,ADMIN,创建,TableSpaceA,TABLESPACE,UserA,Oracle,权限

来源： https://www.cnblogs.com/qianj/p/13578276.html