BlueCielo Meridian Enterprise Server 2017 Administrator's Guide

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.

Warning    Do not use this script to create a Meridian Enterprise vault database. This script is for creating Meridian Explorer repositories only. The database structures for vaults and for Meridian Explorer repositories are different.

To create a Meridian Explorer repository database on the database server:

• In SQLPlus, run the following PL-SQL script. Change <UserName> and <Password> to the desired user name and password respectively.

Oracle script

DEFINE UserName = "<UserName>"
DEFINE Password = "<Password>"
--------------------------------------------------------------------------------
CREATE USER &UserName IDENTIFIED BY &Password 
ACCOUNT UNLOCK 
– DEFAULT TABLESPACE "USERS" 
– TEMPORARY TABLESPACE "TEMP" 
– PROFILE "DEFAULT";
GRANT RESOURCE, CREATE SESSION TO &UserName; – required for Oracle 11(nnk)
GRANT RESOURCE, CONNECT 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 TRIGGER TO &UserName;
GRANT CREATE UNLIMITED TABLESPACE TO &UserName;
– ALTER USER &UserName QUOTA 100M ON USERS;
--GRANT EXECUTE ON "CTXSYS"."CTX_DDL" TO "&UserName";