創建表空間
CREATE TABLESPACE tableName
LOGGING
DATAFILE 'D:\OracleDatabaseFile\tableName.dbf'
SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
創建用戶
CREATE USER username IDENTIFIED BY password
更改用戶的表空間
ALTER USER username DEFAULT TABLESPACE tableName
賦予用戶除DBA以外的權限
GRANT CONNECT,RESOURCE TO username