REM /*******************************************************/
REM /* GRANT and ALTER statements for Oracle Usernames */
REM /*******************************************************/
spool orainst4.log
CREATE USER WCIS_DBA
IDENTIFIED BY wcis_dba
DEFAULT TABLESPACE WORK01
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
;
CREATE USER WCIS_ADMIN
IDENTIFIED BY wcis_admin
DEFAULT TABLESPACE WORK01
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
;
CREATE USER OPS$APPWORX
IDENTIFIED BY isa
DEFAULT TABLESPACE ISA01
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
;
CREATE USER OPS$WCISAUTH
IDENTIFIED BY wcisauth
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
;
CREATE USER DES2000
IDENTIFIED BY des2000
DEFAULT TABLESPACE des2
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
;
REM /*******************************************************/
REM /* GRANT statements for all SYSTEM Privileges */
REM /*******************************************************/
GRANT CONNECT, DBA, UNLIMITED TABLESPACE TO WCIS_DBA;
GRANT CONNECT, DBA, UNLIMITED TABLESPACE TO WCIS_ADMIN;
GRANT CONNECT, DBA, UNLIMITED TABLESPACE TO OPS$APPWORX;
GRANT CONNECT, DBA, UNLIMITED TABLESPACE TO DES2000;
GRANT CONNECT, UNLIMITED TABLESPACE TO OPS$WCISAUTH;
GRANT DELETE ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE TO SYS;
GRANT SELECT ANY TABLE TO SYSTEM;
REM /*******************************************************/
REM /* SET SYSTEM AND SYS default tablespace */
REM /*******************************************************/
ALTER USER SYSTEM DEFAULT TABLESPACE TOOLS TEMPORARY TABLESPACE TEMP;
ALTER USER SYS DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP;
REM /*******************************************************/
REM /* Creation of ALL non-SYS Oracle Roles */
REM /*******************************************************/
create ROLE WCIS_DEVELOPER identified by tigers;
CREATE ROLE WCIS_QUERY;
CREATE ROLE WCIS_USER identified by tigers;
REM /*******************************************************/
REM /* GRANTs for role privileges to users */
REM /*******************************************************/
GRANT WCIS_USER TO WCIS_DEVELOPER;
GRANT WCIS_USER, WCIS_QUERY TO OPS$WCISAUTH;
GRANT WCIS_DEVELOPER, WCIS_QUERY, WCIS_USER TO PUBLIC;
REM /*******************************************************/
REM /* GRANT statements for ADMIN Role Privileges */
REM /*******************************************************/
GRANT WCIS_DEVELOPER, WCIS_QUERY, WCIS_USER TO WCIS_DBA WITH ADMIN OPTION;
GRANT WCIS_DEVELOPER, WCIS_QUERY, WCIS_USER TO WCIS_ADMIN WITH ADMIN OPTION;
REM /*******************************************************/
REM /* Assign Default Roles for all Oracle Accounts */
REM /*******************************************************/
ALTER USER WCIS_DBA DEFAULT ROLE ALL;
ALTER USER WCIS_ADMIN DEFAULT ROLE ALL;
ALTER USER OPS$APPWORX DEFAULT ROLE ALL;
ALTER USER OPS$WCISAUTH DEFAULT ROLE CONNECT, WCIS_QUERY;
REM /*******************************************************/
REM /* Final Shutdown and Startup before import */
REM /*******************************************************/
SHUTDOWN NORMAL
CONNECT INTERNAL
STARTUP RESTRICT OPEN $ORACLE_SID PFILE=$ORACLE_HOME/dbs/init$ORACLE_SID.ora
SPOOL OFF
EXIT