oracle数据库的表空间的建立，用户的建立以及权限的分配

CREATE TABLESPACE UTAN
LOGGING
DATAFILE 'D:\表空间\UTAN01.DBF' 
SIZE 32M 
AUTOEXTEND ON 
NEXT 32M 
EXTENT MANAGEMENT LOCAL;


CREATE USER wangj IDENTIFIED BY wangj
DEFAULT TABLESPACE UTAN;


GRANT 
　　CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
　　ALTER ANY TABLE, ALTER ANY PROCEDURE,
　　DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
　　SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
　　TO utan;


GRANT DBA TO wangj;