AnsweredAssumed Answered

Clarity installation instructions missing a critical word

Question asked by another_martink on Feb 25, 2014
Latest reply on Mar 4, 2014 by another_martink

Looking at the Clarity v13.0 - v13.3 Installation guide at the SQL server set up instructions it appears that there is a word missing in the command given

 

12.1.
VIEW_SERVER_STATE  Granted to database user.
To apply, execute:
GRANT VIEW SERVER STATE to niku

12.1. SP 3
VIEW_SERVER_STATE  Granted to database user.
To apply, execute:
GRANT VIEW SERVER STATE to niku

13.0
Does not have that at all and the last step in the instructions is
5.  Associate the imported database with your organization's SQL server security user
by running the following pl/sql as the sa user:
USE niku
ALTER USER niku WITH LOGIN=<your security user>

13.1 13.2 and 13.3
6.  Grant the VIEW SERVER STATE to the <your security user> user:
GRANT SERVER STATE to <your security user>

 

The word VIEW is missing from the last line though it is in the above line.

If you leave it out your installation goes to the dogs.

For v13.3 that is located in

Chapter 2: How to Set Up the CA Clarity  PPM Database
Configure Microsoft SQL Server
Review the Imported Database Options

 

Martti K.

Outcomes