代码：

//dba账户登录sqlplus请输入用户名：dpp_data as sysdba请输入口令：dpp_data//创建账号create user techrpt_data identified  by techrpt_data;//创建临时表空间create temporary tablespace TECHRPT_DATA_TEMPtempfile 'D:\ORACLE\ORADATA\ORCL\TECHRPT_DATA_TEMP.dbf'size 32mautoextend onnext 32m maxsize 2048mextent management local;//将临时表空间分配给用户alter user techrpt_data temporary tablespace TECHRPT_DATA_TEMP;//创建表空间create tablespace TECHRPT_DATA logging  datafile 'D:\ORACLE\ORADATA\ORCL\TECHRPT_DATA.ora' size 50m  autoextend on  next 50m maxsize 2048m  extent management local; //将表空间分配给用户alter user techrpt_data default tablespace TECHRPT_DATA;//授权grant dba to techrpt_data;grant connect,resource to techrpt_data;grant create session to techrpt_data;grant create any sequence to techrpt_data;grant create any table to techrpt_data;grant delete any table to techrpt_data;grant insert any table to techrpt_data;grant select any table to techrpt_data;grant update any table to techrpt_data;grant unlimited tablespace to techrpt_data;grant execute any procedure to techrpt_data;grant create any view to techrpt_data;grant select on v_$statname to techrpt_data; grant select on v_$sesstat to techrpt_data; grant select on v_$session to techrpt_data; grant select on v_$mystat to techrpt_data;//提交commit;//退出quit;//删除用户drop user techrpt_data cascade;//删除表空间drop tablespace techrpt_data including contents and datafiles;//修改密码alter user system identified by system;