1.创建表空间
CREATE SMALLFILE TABLESPACE username_tablespace DATAFILE ‘F:\app\Administrator\oradata\orcl\ username_tablespace.dbf’ SIZE 1000M AUTOEXTEND ON NEXT 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
2.创建用户
CREATE USER username PROFILE DEFAULT IDENTIFIED BY password DEFAULT TABLESPACE username_tablespace TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK;
3.赋权限
GRANT CONNECT TO username;
GRANT RESOURCE TO username;
GRANT DBA TO username;
GRANT CREATE ANY VIEW TO username;
GRANT CREATE PUBLIC DATABASE LINK TO username;
GRANT UNLIMITED TABLESPACE TO username;