创建一个oracle用户sql语句

create temporary tablespace liferay6_temp
tempfile '/opt/oracle/oradata/liferay6_temp.dbf'
size 32m
autoextend on
next 32m maxsize 1024m
extent management local;

create tablespace liferay6_data
logging
datafile '/opt/oracle/oradata/liferay6_data.dbf'
size 32m
autoextend on
next 32m maxsize 1024m
extent management local;

create user liferay6 identified by liferay6
default tablespace liferay6_data
temporary tablespace liferay6_temp;

grant connect, resource, IMP_FULL_DATABASE, EXP_FULL_DATABASE to liferay6;