1 CREATE TABLESPACE tablespcename DATAFILE 'C:\oracle\oradata\axp\tablespcename.DBF' SIZE 100M AUTOEXTEND ON NEXT 10M; 2 3 -- Create the user 4 create user jhabb 5 identified by jhabb 6 default tablespace tablespcename 7 temporary tablespace TEMP; 8 9 10 GRANT DBA TO jhabb; 11 GRANT unlimited tablespace to jhabb; 12 GRANT alter any procedure to jhabb; 13 GRANT create procedure to jhabb; 14 GRANT create session to jhabb; 15 GRANT create table to jhabb; 16 GRANT create view to jhabb; 17 GRANT select any table to jhabb; 18 GRANT create any trigger to jhabb; 19 GRANT create sequence to jhabb; 20 GRANT create type to jhabb;
平时用的多，做个备份。