1 *分为四步 */ 2 /*第1步：创建临时表空间 */ 3 create temporarytablespace user_temp 4 tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf' 5 size 50m 6 autoextend on 7 next 50m maxsize 20480m 8 extent management local; 9 10 /*第2步：创建数据表空间 */ 11 create tablespace user_data 12 logging 13 datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf' 14 size 50m 15 autoextend on 16 next 50m maxsize 20480m 17 extent management local; 18 19 /*第3步：创建用户并指定表空间 */ 20 create user username identified by password 21 default tablespace user_data 22 temporary tablespace user_temp; 23 24 /*第4步：给用户授予权限 */ 25 grant connect,resource,dba to username;
浙公网安备 33010602011771号