创建表空间
create tablespace ekpv16 datafile 'D:\oraclexe\app\oracle\oradata\XE\ekpv16.dbf' size 100m AUTOEXTEND on next 20m logging
创建用户ekpv16,口令:ekpv16,指定默认表空间ekpv16,临时表空间temp
create user ekpv16 IDENTIFIED BY ekpv16 default TABLESPACE ekpv16 TEMPORARY TABLESPACE temp
授权用户创建表,创建视图,创建序列,创建对话,对表空间大小不加限制权限,和授予用户最典型、开发人员和系统管理角色
GRANT create table,create view,create sequence,create session,unlimited tablespace TO ekpv16;
GRANT connect TO ekpv16;
GRANT resource TO ekpv16;
GRANT dba TO ekpv16;