Hi,
We have multiple security groups configured in our environment and perform routine auditing. At the moment auditing of the permissions must be done visually by accessing the Cube and viewing the permissions for each group which is time consuming.
Is there a way for the groups permissions to be viewed either in a configuration file or if you have a SQL query that can get the permissions for a group from any SQL table?
DM Version - 9.6 CU23
Database - MS SQL Database
Hi,
The permissions are not stored in the database. Unfortunately, there is no good way to view individual group permissions, other than manually using Cube.