oracle建表空间及用户创建和授权

–删除表空间
DROP TABLESPACE xchlw INCLUDING CONTENTS AND DATAFILES;

–创建表空间
Create tablespace xchlw datafile ‘D:\oracledata\xchlw.dbf’ size 100m autoextend on next 10M maxsize unlimited;

– 创建用户
Create user 用户名 identified by 密码;
Create user xchlw identified by zaq1 ;
Create user xchlw identified by zaq1 default tablespace xchlw;

–修改默认表空间
alter user xchlw default tablespace xchlw;

–给用户授权
grant Create session, Create table, Create view,Create sequence,unlimited tablespace ,connect,resource,dba to xchlw;