1.创建用户、表空间、给用户授权
create user study identified by study;--创建用户 create tablespace STUDY datafile 'D:oraclexeD:oraclexeoradataXESTUDY.dbf'size 50m;--创建表空间 alter user study default tablespace STUDY;--将表空间分配给用户 grant create session,create table,unlimited tablespace to study; --给用户授权 grant create view,create trigger,create sequence,create procedure to study;--分配创建表，视图，触发器，序列，过程，权限 grant connect,resource,dba to study;--授予dba权限