Guest

Preview Tool

Cisco Bug: CSCvh80994 - Instructions for adding SQL user for Live Data are incomplete

Last Modified

Jan 16, 2019

Products (1)

  • Cisco Unified Contact Center Enterprise

Known Affected Releases

11.6(1)

Description (partial)

Symptom:
The query for allowing a SQL user created to work with Live Data described below will receive an error stating "Cannot find the user '<user>', because it does not exist or you do not have permission."

USE master
GO
GRANT CONTROL ON CERTIFICATE :: UCCESymmetricKeyCertificate TO "<user>"
GRANT VIEW DEFINITION ON SYMMETRIC KEY :: UCCESymmetricKey TO "<user>"

Conditions:
The newly created user does not have permission to run the required query.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.