//建立表空间

create  tablespace t_work
datafile ‘E:\20141122_work\work.dbf‘
size 100m
autoextend on

//创建用户
create user lln2
identified by 123
default tablespace t_work
temporary tablespace temp

//为用户分配权限

grant connect,resource,dba to lln2

Oracle语法01