XXX项目部署文档

格式：doc
大小：64.50 KB
文档页数：4

下载文档原格式

/ 11

1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。

XXX项目部署文档

一、安装数据库软件并建立实例

1、安装数据库软（win32_11gR1_database.rar）

2、单独搭建实例（XXDB）

二、建对应的表空间、用户

1、搭建必要的表空间

CREA TE TABLESPACE TBS_XXX1

DA TAFILE 'F:\app\oradata\ TBS_XXX1.DBF' SIZE 1024M AUTOEXTEND ON;

CREA TE TABLESPACE TBS_XXX2

DA TAFILE 'E:\app\oradata\ TBS_XXX2.DBF' SIZE 1024M AUTOEXTEND ON;

CREA TE TABLESPACE TBS_XXX3

DA TAFILE 'F:\app\oradata\PLM_TEST1.DBF' SIZE 2048M AUTOEXTEND ON;

CREA TE TEMPORARY TABLESPACE TBS_XXX4

TEMPFILE 'E:\app\oradata\ TBS_XXX3.dbf' SIZE 500M AUTOEXTEND ON;

2、建立用户

CREA TE USER USER_XXX1 IDENTIFIED BY USER_XXX1

DEFAULT TABLESPACE TBS_XXX1

temporary tablespace TEMP;

Grant Dba To USER_XXX1;

-- Create the user

create user USER_XXX2 identified by USER_XXX2

default tablespace TBS_XXX2

temporary tablespace TEMP;

grant dba to USER_XXX1;

grant unlimited tablespace to USER_XXX1;

create user USER_XXX3 identified by USER_XXX3

default tablespace TBS_XXX2

temporary tablespace TEMP;

grant create session to USER_XXX3 with USER_XXX1 option;

create user USER_XXX4 identified By USER_XXX4

default tablespace TBS_XXX2

temporary tablespace TEMP;

grant create session to USER_XXX4 with USER_XXX1 option;

3、通过系统管理员角色授权

grant select on USER_XXX1.ASN_DETAIL to USER_XXX1;

grant select on USER_XXX1.ASN_HEAD to USER_XXX1;

grant select on USER_XXX1.CGDD_DETAIL to USER_XXX1;

grant select on USER_XXX1.CGDD_HEAD to USER_XXX1;

grant select on USER_XXX1.SHDD to USER_XXX1;

grant select, insert, update on USER_XXX1.DEPARTMENT to USER_XXX1; grant select on USER_XXX1.DEPARTMENT_ID_SEQ to USER_XXX1;

grant select, insert, update on USER_XXX1.ERP_PO_VENDOR to USER_XXX1; grant select, insert, update on USER_XXX1.GET_LOG to USER_XXX1;

grant select, insert, delete on USER_XXX1.ITEM to USER_XXX1;

grant select on USER_XXX1.ITEM_ID_SEQ to USER_XXX1;

grant select, insert on USER_XXX1.ITEM_STRUCT to USER_XXX1;

grant select on USER_XXX1.ITEM_STRUCT_ID_SEQ to USER_XXX1;

grant select, insert, update on USER_XXX1.JHY to USER_XXX1;

grant select on USER_XXX1.JHY_ID_SEQ to USER_XXX1;

grant insert on USER_XXX1.JPEI_PLAN to USER_XXX1;

grant select on USER_XXX1.JPEI_PLAN_ID_SEQ to USER_XXX1;

grant insert on USER_XXX1.JSHENG_JUN_PLAN to USER_XXX1;

grant select on USER_XXX1.JSHENG_JUN_PLAN_ID_SEQ to USER_XXX1; grant insert on USER_XXX1.JSHENG_PLAN to USER_XXX1;

grant select on USER_XXX1.JSHENG_PLAN_ID_SEQ to USER_XXX1;

grant insert on USER_XXX1.JSHI_PLAN to USER_XXX1;

grant select on USER_XXX1.JSHI_PLAN_ID_SEQ to USER_XXX1;

grant insert on USER_XXX1.JZHUAN_PLAN to USER_XXX1;

grant select on USER_XXX1.JZHUAN_PLAN_ID_SEQ to USER_XXX1;

grant insert on USER_XXX1.MANUPLAN to USER_XXX1;

grant select on USER_XXX1.MANUPLAN_ID_SEQ to USER_XXX1;

grant select, insert, update on USER_XXX1.MA TERIAL to USER_XXX1;

grant select on USER_XXX1.MA TERIAL_ID_SEQ to USER_XXX1;

grant insert on USER_XXX1.SUPPLIER_LIST2 to USER_XXX1;

grant select on USER_XXX1.SUPPLIER_SEQ to USER_XXX1;

grant select on USER_XXX1.SUPP_INVENTORY to USER_XXX1;

grant select, insert, update on USER_ERS to USER_XXX1;

grant insert on USER_XXX1.VEHICLE_STRUCT to USER_XXX1;

grant select on USER_XXX1.VEHICLE_STRUCT_ID_SEQ to USER_XXX1; grant select, insert, delete on USER_ER_XXX2_KC to USER_XXX1; grant select on USER_ER_XXX2_KC_ID_SEQ to USER_XXX1;

grant insert, delete on USER_ER_XXX2_MA TERIAL to USER_XXX1; grant select on USER_ER_XXX2_MA TERIAL_ID_SEQ to USER_XXX1; grant insert on USER_XXX1.ZPEI_PLAN to USER_XXX1;