KB483112: "You do not have access to the DB connection object 'XYZ'" error appears when creating or editing a Logical View in MicroStrategy Developer

Cloud Support Expert I • MicroStrategy

This Knowledge Base article describes an error that appears when a user tries to create a Logical Table in MicroStrategy Developer, due to some lack of privileges.

SYMPTOM
When a user tries to create a new logical table, the following error appears, in Strategy Developer:


User 'YY' does not have Read access to the DB connection object 'XYZ' in Project Configuration with ID 'ID'

Furthermore, when trying to edit an existing table, the Save and Close button is greyed out.
CAUSE
The error indicates a lack of privileges to access the DB Connection object mentioned in the message. In order to find the DB Connection object, follow these steps:

In Strategy Developer, connect to the Project Source and go to Administration menu > Search for Configuration Objects
In the Object Types tab, check Only these types of object and select Database Connection
Search for the DB Connection object
Right mouse click on the db connection object and go to Properties > Security; verify that the user or the user group has the right ACLs

ACTION
Assign View privileges to the user or the user groups. KB483112

Comment

0 comments

Details

Knowledge Article

Published:

April 2, 2019

Last Updated:

February 26, 2024