oracle创办表空间，定义用户，用户授权

oracle创建表空间，定义用户，用户授权
--创建表空间
create tablespace hmldata

datafile 'D:\oracle\oradata\DBF\hmldata.dbf'

size 100M AutoExtend On Next 10M Maxsize 2048M

extent management local

segment space management auto

--创建用户
create user hmltest identified by hmltest

default tablespace hmldata

temporary tablespace temp;

--为用户授权
-- Grant/Revoke role privileges
grant dba to HMLTEST;
-- Grant/Revoke system privileges
grant unlimited tablespace to HMLTEST;