what is the SQL statement for the KPI/Module/Group Secuirty tab in Security Management module in ARC?

• Related Articles

• KPI Module/Group Security page of the Roles/User Browser in Security Management of Administrator module is showing wrong information. How can it be corrected?

  To correct the information, replace the query 'SECURITY_USER_ROLE' with the query as provided below in the admin_mysql_admin.xml file: SECURITY_USER_ROLE SELECT DISTINCT ...

• Users Browser Tab under the Security Management in Admin module does not display the users. Why?

  All users created will be displayed in the User Browser tab. In the summary section of the screen, the number of users displayed depends on the number set in the Show Per Page section at the right bottom of the screen. You can use the Pagination ...

• I cannot disable all modules/KPIs from Analyst module using the KPI Module/Group Security at Role level (Store Manager). How to fix it?

  In order to apply KPI Module/Group level security, ensure that nothing is assigned at the USER level and also at the DEPARTMENT level (If a 3-level security of Department -> Role -> User is implemented).

• The module created is not displayed in security management and the new Module/KPI is greyed out in Security Management while trying to assign to super users. How can I fix this?

  Please ensure that you create at least one KPI once a new Module is added. If the newly added module does not contain any KPIs, then it will not be displayed in security management. Additionally, there is no need to assign this to Super users. By ...

• All Users are not listing out in User's Browser tab in Security Management.

  There is a pagination available in the User's Browser tab in order to view all Users. Check for this option