/*分为四步 */
/*第1步:创建临时表空间 */
CREATE TEMPORARY TABLESPACE [临时表空间名称]
TEMPFILE 'D:\ORACLEDATA\[临时表空间名称]_[编号(如01)].DBF'
SIZE 50M
AUTOEXTEND ON
NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
/*第2步:创建数据表空间 */
CREATE TABLESPACE [数据表空间名称]
LOGGING
DATAFILE 'D:\ORACLEDATA\[数据表空间名称]_[编号(如01)].DBF'
SIZE 50M
AUTOEXTEND ON
NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
/*第3步:创建用户并指定表空间 */
CREATE USER [用户名] IDENTIFIED BY [密码]
DEFAULT TABLESPACE [数据表空间名称]
TEMPORARY TABLESPACE [临时表空间名称];
/*第4步:给用户授予权限 */
--dba权限
GRANT CONNECT, RESOURCE, DBA TO [用户名];
--开发权限
GRANT CONNECT,RESOURCE TO [用户名];
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO [用户名];