Oracle创建用户

创建表空间

create tablespace Name
logging datafile 'D:\oracle\oradata\Name.dbf'
size 100m autoextend on
next 50m maxsize 20480m extent management local;

创建用户

create user Name identified by Password;

赋予权限

grant connect,resource to Name;
grant dba to Name;