Oracle初始化数据系列一：创建表空间、账号、授权

 

/**==========Oracle数据库下执行===================================================**/
/**==========创建表空间，需以DBA身份登陆==========================================**/
PROMPT 基础信息运行维护管理系统 SQL版本V1.0.0
PROMPT 正在创建表空间...

CREATE TABLESPACE "EMS" 
LOGGING 
DATAFILE 'D:\app\user\oradata\orcl\EMS.ORA' SIZE 
50M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  
AUTO;

/**==========创建用户，需以DBA身份登陆============================================**/
PROMPT 创建表空间完成，正在创建用户...
CREATE USER "EMS"  PROFILE "DEFAULT" 
IDENTIFIED BY "EMS" DEFAULT TABLESPACE "EMS" 
TEMPORARY TABLESPACE "TEMP" 
ACCOUNT UNLOCK;
commit;
PROMPT 创建用户完成，开始给用户授权...

/**==========用户授权，需以DBA身份登陆===========================================**/
GRANT CONNECT TO EMS;
GRANT RESOURCE TO EMS;
GRANT CREATE ANY PROCEDURE TO EMS;
GRANT CREATE ANY SEQUENCE TO EMS;
GRANT CREATE ANY TABLE TO EMS;
GRANT CREATE ANY VIEW TO EMS;
GRANT DELETE ANY TABLE TO EMS;
GRANT SELECT ANY TABLE TO EMS;
GRANT UNLIMITED TABLESPACE TO EMS;
GRANT UPDATE ANY TABLE TO EMS;
GRANT DBA TO EMS;

PROMPT 完成.