Hello, everyone,
I've created a database view so that you can generate access reports for user groups according to the roles and ACL types associated with these roles.
My databaseview looks like this:
Problem:
Groups that have only one role, for example, are appearing in duplicate form when there is an ACL using the same role as this group for another table.
Example:
“Group A” has a customized role called xpto and this role is in the ACL of the sys_user_grmember table
When I access my database view from the list, “Group A” appears twice, with the ACL column of the sys_security_acl table displaying a value for the ACL of the “sys_user_grmember” table and another for an ACL of another database view that I have but which has the same role as “Group A” (role xpto).
I would like to understand where the problem lies, or if it is a problem.
I've attached the configuration of my databaseview for help.
Best regards,
Hi @Igor Corr_a
That's not a problem and I think is showing correctly,
In your case, The role is assigned to a group and that role is used in 2 ACL's.
Example: analytics_admin role is assigned to only 1 group and that role is used in 20 ACL's.
