Appendix F: Oracle database creation script

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

To create a repository database on the database server:

1. In SQLPlus, run the following PL-SQL script to create an empty database. 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>;