Oracle筑表空间、建用户、为用户授权语句

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;