Discovery Accelerator (DA) Client users cannot connect to the DA server

book

Article ID: 100050776

calendar_today

Updated On:

Description

Error Message

You do not have permission to access the instance 'CustomerName'

Cause

This has been found to occur when the DA Customer database has been manually updated in an effort to remove orphaned users and their associated permissions through the article linked below. The UPDATE query (supplied by Veritas Technical Support) applies an end date to one of the tables associated to the permission history of the impacted user. By contrast, a user with active permissions will find a NULL entry for the end date.

Resolution

If feasible, the quickest solution is to restore the database to a point prior to the issue taking place. Alternatively, one can find the roles associated to the user in question, remove all of the role assignments, then reapply the role assignment. It has also been found that sometimes the Role itself needs to be reset by changing an Allow permission to a Deny permission, then back to Allow. The same needs to be done with the Deny permissions: First change to Allow then change back to Deny. This needs to be done on all permissions of the Role. Once everything has been switched back to its original state, click Save.

How to find users with orphaned Permissions in the Accelerators

Issue/Introduction

DA client users are denied access to the DA Customer although Roles and Role Assignments appear to be valid.