Cisco Cisco Prime Service Catalog 10.0 Installation Guide

GRANT

  CREATE SESSION,

  CREATE TABLE,

  CREATE PROCEDURE,

  CREATE SEQUENCE,

  CREATE TRIGGER,

  CREATE VIEW,

  CREATE MATERIALIZED VIEW,

  CREATE SYNONYM,

  ALTER SESSION

TO DMUser;

 

Create another database user named CSUser , with default tablespace set to DATAMART and 
temporary tablespace set to DATAMART_TEMP. CSUser should be granted QUOTA UNLIMITED 
on the DATAMART tablespace.  CSUser will be the owner of the ContentStore schema.

Grant the following permissions to CSUser :

 

GRANT

CREATE SESSION,

CREATE TABLE,

CREATE PROCEDURE,

CREATE SEQUENCE,

CREATE TRIGGER,

CREATE VIEW

TO CSUser;

 

 
.

For new installation, you can prepare the Datamart and ContentStore databases and login users as 
described in this section before executing the Reporting installer, or you can let the Reporting installer 
create the databases and login users for you by selecting the "Create Database" option presented by the 
installation wizard. The "Create Database" option of the Reporting installer is described in more detail 
in the "Installing Reporting" section.

To create the Datamart and ContentStore databases and login users:

SQL Server must be installed as “Default Instance”. It cannot be a “Named Instance”.

SQL Server must be configured with mixed-mode authentication (that is, allows both SQL Server 
authentication and Windows authentication).

Create two separate databases called "Datamart" and "ContentStore", each with initial size of 500 
MB and autogrowth by 10 percent. The collating sequence of each database must be 
case-insensitive.

Create two separate database login accounts named "DMUser" and "CSUser".

DMUser and CSUser must be SQL Server login accounts that authenticate to the SQL Server using SQL 
Server authentication method, and not Windows authentication method.