KB45514: How to hide a database instance from specific users or groups, when configuring a data mart report in MicroStrategy Developer 9.x?

SYMPTOM:
 
In this scenario it may be desired that a specific user or group should not be able to select one of the configured database instances, when configuring data mart reports. For this example, the user "test" should not be able to select the database instance "Tutorial Data".
 
However, when configuring a data mart, the user sees this database instance:

 
CAUSE:
 
This user or user's group has "Browse" access to this specific database instance.
 
ACTION:
 
Add this user or group to the database instance security properties, and set "Browse" access to "Deny".

• Open the database instance properties by performing a right-click, and selecting "Properties":
  

• Under "Properties" -> "Security", click "Add..." to locate and add your user or group to the list.
• For the user/group, click on the "Object" and select "Custom...":
  

• For the permission "Browse", set the Type to "Deny":
  

 
The next time this user attempts to log in, they will no longer see this database instance: