Oracle建表空间、建用户、为用户授权语句
新建表空间：
create tablespace mzhdb datafile 'e:\OracleXE\oradata\XE\mzhdb.dbf' size 200M autoextend on next 10M maxsize unlimited logging extent management local autoallocate segment space management auto;
新建用户：
create user mzhidentified by mzhdefault tablespace mzhdbtemporary tablespace tempaccount unlock
给用户授权：
grant dba to mzh;grant connect to mzh;grant resource to mzh;