ORCLE 创建表空间，用户，赋予角色以及授权

1、创建表空间MMS_DATA

--创建表空间和数据库文件dbf
CREATE TABLESPACE MMS_DATA DATAFILE 
  'D:\ORADATA\ORCL\MMS_DATA.DBF' 
  SIZE 3096M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

2、创建临时表空间MMS_TEMP

--创建临时表空间和数据库文件dbf
CREATE TEMPORARY TABLESPACE MMS_TEMP TEMPFILE 
  'D:\ORADATA\ORCL\MMS_TEMP.DBF' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
TABLESPACE GROUP ''
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

3、创建用户MMS并解锁

CREATE USER MMS
  IDENTIFIED BY VALUES 'MMS'
  DEFAULT TABLESPACE MMS_DATA 
  TEMPORARY TABLESPACE MMS_TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;

4、赋予角色

 GRANT CONNECT TO MMS ;
  GRANT RESOURCE TO MMS ;
  GRANT EXP_FULL_DATABASE TO MMS;
  ALTER USER MMS DEFAULT ROLE ALL; 

5、赋予系统权限 创建/修改/删除任何表  创建视图 给用户

-- 1 System Privilege for MMS
  GRANT CREATE ANY TABLE TO MMS;
  GRANT ALTER ANY TABLE TO MMS;
  GRANT DROP ANY TABLE TO MMS;   
  GRANT UNLIMITED TABLESPACE TO MMS;
  GRANt CREATE VIEW TO MMS;