创建WPS数据库用户
创建以下sql文件:04createWPSOraUser.sql(修改所需内容)
REM *******************************************************************
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 |
用oracle用户登录到数据库服务器上执行以下语句,以创建(注意,sql文件当中定义的目录需要事先手工创建好,否则执行时会出错!)
sqlplus sys/<yourPassword>@ORCL AS SYSDBA @04createWPSOraUser.sql
|
检查运行结果,看看是否有错误发生。
创建WPS数据库XA Recovery用户
创建以下sql文件:05AcreateWPSrecoveryUser.sql(修改所需内容)
REM *******************************************************************
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 |
用oracle用户登录到数据库服务器上执行以下语句,以创建(注意,sql文件当中定义的目录需要事先手工创建好,否则执行时会出错!)
sqlplus sys/<yourPassword>@ORCL AS SYSDBA @05AcreateWPSrecoveryUser.sql
|
检查运行结果,看看是否有错误发生。
让所有WPS数据库用户获得recovery权限
创建以下sql文件:05BgrantWPSallUsersRecoveryPrivileges.sql(修改所需内容)
REM *******************************************************************
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 |
用oracle用户登录到数据库服务器上执行以下语句,以创建(注意,sql文件当中定义的目录需要事先手工创建好,否则执行时会出错!)
sqlplus sys/<yourPassword>@ORCL AS SYSDBA @05BgrantWPSallUsersRecoveryPrivileges.sql
|
检查运行结果,看看是否有错误发生。
创建WPS数据库CEI用户权限配置
创建以下sql文件:07AgrantCEIOraInstRights.sql(修改所需内容)
REM *******************************************************************
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 |
用oracle用户登录到数据库服务器上执行以下语句,以创建(注意,sql文件当中定义的目录需要事先手工创建好,否则执行时会出错!)
sqlplus sys/<yourPassword>@ORCL AS SYSDBA @07AgrantCEIOraInstRights.sql
|
检查运行结果,看看是否有错误发生。
让所有WPS数据库CEI用户获得额外权限
以下文章点击率最高
Loading…