Hi all,
I'm a new one with Metric studio and Metric Designer. By reading the Cognos documentation, I saw that for create the structure of the metric store database we need to launch the batch file "cmm_create_db.cmd" located in ..\c8\configuration\schemas\cmm\oracle. And we MUST to launch this batch file on the Oracle database server with Admin user! Cognos 8 BI application and Oracle databases (content store) are not stored on the same server and I don't have access to the Oracle database server directly and I don't have admin rights on the database instance.
I have just asked to my DBA admin to create an empty Oracle user/schema for metric store access with the correct rights/privileges required by Cognos and I believed that I can create the database structure of the metric store with this user and not use a SYS DBA user.
So, is there an other way to create the structure of the metric store when we don't have access to the Oracle database server as SYS DBA user.
Thanks in advanced for your help.
The user need the following privileges to create metric store
DBMS_UTILITY,
DBMS_LOCK
CREATE TABLE,CREATE VIEW,CREATE PROCEDURE,CREATE TRIGGER,CREATE TYPE,CREATE SEQUENCE,CREATE SESSION,tablespace privileges