CVP Reporting User Created from OAMP Cannot Access Callback Database

Introduction

This document describes a work around to the issue when a newly created reporting users through the Cisco Unified Customer Voice Portal (CVP)  Operation Console (OAMP) cannot access the callback database.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

• CVP Reporting Server
• CVP OAMP

Components Used

The information in this document is based on these software versions:

• CVP Reporting Server  10.5 and above
• CVP OAMP 10.5 and above

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Problem Description

From the Unified CVP OAMP reporting users can be created but with read-only database access to the Unified CVP Informix reporting database. These users are expected to have the basic "Log in User" user role and have read access to all the tables. The problem is that these new reporting user cannot access "Callback Tables" with a non-default Reporting user created from OAMP.

Resolution

The issue is registered in  "CSCuw43956 "

As a workaround for this issue you can manually grant permissions to new users:

Step 1. On Reporing Server perform dbaccess via the command prompt. You can launch the command prompt and then
navigate to the path c:\db\informix and you can type in dbaccess.

Step 2. Connect to the callback db using the dbaccess.

Step 3. Run the following query SELECT * FROM SYSUSERS;
Validate in the result, check if the <username> is present with usertype as C,R or D.

Step 4. If these users are not present run the below commands to grant privilege to the users.

For Non-DBA access Run "GRANT CONNECT TO <username>;"
For DBA access Run "GRANT DBA TO <username>;"