Appendix D: Oracle database creation script

If your account on the Explorer server does not have sufficient privileges to create a new database on the database server using the BlueCielo Meridian Explorer Database Wizard as described in Creating a repository, you can create the Meridian Explorer repository database with the following script.

For Oracle only, create the database using the following PLSQL script file. Change <UserName> and <Password> to the desired user name and password respectively.

To create a repository database on the database server:

1. In SQLPlus, run the following PL-SQL script to create an empty database.

1. Change every occurrence of <UserName> and <Password> to the desired user name and password respectively.

Oracle script

CREATE USER <UserName> IDENTIFIED BY <Password>; 
GRANT RESOURCE, CREATE SESSION TO <UserName>;
GRANT RESOURCE, CONNECT TO <UserName>;
GRANT CTXAPP TO <UserName>;
GRANT EXECUTE ON CTX_DDL TO <UserName>;
GRANT CREATE VIEW TO <UserName>;
GRANT ALTER ANY TABLE TO <UserName>;
GRANT CREATE PROCEDURE TO <UserName>;
GRANT CREATE VIEW TO <UserName>;