WPS V7 ON AIX WITH ORACLE群集安装记录(14）

REM File: 04createWPSOraUser.sql

REM Date: 2009-05-04

REM

REM Desc: Create all Oracle database user for WPS 6.2.0.1

112

REM

REM Usage:

REM 1. Define db user names

REM 2. Define db user passwords for all WPS user

REM 3. Optional: Adjust default tablespaces.

REM 4. Execute the sql script as user oracle on the database host.

REM *******************************************************************

REM Create user for WPS common db

CREATE USER WPS_COMMONDB IDENTIFIED BY WPS_COMMONDB DEFAULT TABLESPACE WPS_COMMON_TBS;

GRANT WPS_USER_ROLE TO WPS_COMMONDB;

GRANT UNLIMITED TABLESPACE TO WPS_COMMONDB;

REM Create user for SCA application message engine

CREATE USER WPS_SCAAPPMSG IDENTIFIED BY WPS_SCAAPPMSG DEFAULT TABLESPACE WPS_MEAPP_TBS;

GRANT WPS_USER_ROLE TO WPS_SCAAPPMSG;

GRANT UNLIMITED TABLESPACE TO WPS_SCAAPPMSG;

REM Create user for SCA system message engine

CREATE USER WPS_SCASYSMSG IDENTIFIED BY WPS_SCASYSMSG DEFAULT TABLESPACE WPS_MESYS_TBS;

GRANT WPS_USER_ROLE TO WPS_SCASYSMSG;

GRANT UNLIMITED TABLESPACE TO WPS_SCASYSMSG;

REM Create user for CEI message engine

CREATE USER WPS_CEIMSG IDENTIFIED BY WPS_CEIMSG DEFAULT TABLESPACE WPS_MECEI_TBS;

GRANT WPS_USER_ROLE TO WPS_CEIMSG;

GRANT UNLIMITED TABLESPACE TO WPS_CEIMSG;

REM Create user for BPC message engine

CREATE USER WPS_BPCMSG IDENTIFIED BY WPS_BPCMSG DEFAULT TABLESPACE WPS_MEBPC_TBS;

GRANT WPS_USER_ROLE TO WPS_BPCMSG;

GRANT UNLIMITED TABLESPACE TO WPS_BPCMSG;

REM Create user for BPC data

CREATE USER WPS_BPCDB IDENTIFIED BY WPS_BPCDB;

GRANT WPS_USER_ROLE TO WPS_BPCDB;

GRANT UNLIMITED TABLESPACE TO WPS_BPCDB;

REM Create user for BPC Observer data

CREATE USER WPS_BPCOBS IDENTIFIED BY WPS_BPCOBS;

GRANT WPS_USER_ROLE TO WPS_BPCOBS;

GRANT UNLIMITED TABLESPACE TO WPS_BPCOBS;

REM Create user for CEI data

CREATE USER WPS_CEIDB IDENTIFIED BY WPS_CEIDB;

GRANT WPS_USER_ROLE TO WPS_CEIDB;

GRANT UNLIMITED TABLESPACE TO WPS_CEIDB;

REM Create user for Business Space data

CREATE USER WPS_BSPACE IDENTIFIED BY WPS_BSPACE;

GRANT WPS_USER_ROLE TO WPS_BSPACE;

GRANT UNLIMITED TABLESPACE TO WPS_BSPACE;

REM Commit work

COMMIT;

EXIT

sqlplus sys/<yourPassword>@ORCL AS SYSDBA @04createWPSOraUser.sql

REM File: 05createWPSrecoveryUser.sql

REM Date: 2009-05-04

REM

REM Desc: Create WPS recovery database user for WPS 6.2.0.1

REM

REM Usage:

REM 1. Define db user names

REM 2. Define db user passwords for WPS recovery user

REM 3. Execute the sql script as user oracle on the database host.

REM *******************************************************************

REM Create WPS recovery user

CREATE USER WPS_RECOVERY IDENTIFIED BY WPS_RECOVERY;

GRANT WPS_USER_ROLE TO WPS_RECOVERY;

GRANT WPS_RECOVERY_ROLE TO WPS_RECOVERY;

REM Commit work

COMMIT;

EXIT

sqlplus sys/<yourPassword>@ORCL AS SYSDBA @05AcreateWPSrecoveryUser.sql

REM File: 05BgrantWPSallUSersRecoveryPrivileges.sql

REM Date: 2009-05-04

REM

REM Desc: Grant all Oracle database user the XA recovery privileges.

REM

REM Usage:

REM 1. Define db user names

REM 2. Execute the sql script as user oracle on the database host.

REM *******************************************************************

GRANT WPS_RECOVERY_ROLE TO WPS_COMMONDB;

GRANT WPS_RECOVERY_ROLE TO WPS_SCAAPPMSG;

GRANT WPS_RECOVERY_ROLE TO WPS_SCASYSMSG;

GRANT WPS_RECOVERY_ROLE TO WPS_CEIMSG;

GRANT WPS_RECOVERY_ROLE TO WPS_BPCMSG;

GRANT WPS_RECOVERY_ROLE TO WPS_BPCDB;

GRANT WPS_RECOVERY_ROLE TO WPS_BPCOBS;

GRANT WPS_RECOVERY_ROLE TO WPS_CEIDB;

GRANT WPS_RECOVERY_ROLE TO WPS_BSPACE;

REM Commit work

COMMIT;

EXIT

sqlplus sys/<yourPassword>@ORCL AS SYSDBA @05BgrantWPSallUsersRecoveryPrivileges.sql

REM File: 07AgrantCEIOraInstRights.sql

REM Date: 2009-05-04

REM

REM Desc: Grant all needed privileges for installation/migration

REM to CEI db user for WPS 6.2.0.1

REM

REM Usage:

REM 1. Define db user name

REM 2. Execute the sql script as user oracle on the database host.

REM *******************************************************************

REM Grant install/migration privileges for CEI user

GRANT CREATE TABLESPACE TO WPS_CEIDB;

GRANT DROP TABLESPACE TO WPS_CEIDB;

GRANT CREATE TABLE TO WPS_CEIDB;

GRANT CREATE VIEW TO WPS_CEIDB;

REM Commit work

COMMIT;

EXIT

sqlplus sys/<yourPassword>@ORCL AS SYSDBA @07AgrantCEIOraInstRights.sql