Oracle语法01
时间:2022-03-14 02:51
//建立表空间
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