Checking Parameter And Query For Allow Orchestrator UI Access Activation Status Of Users

News Knowledge Base
,
1

What parameters should be checked in the database and which query should be used to extract the users who have the "Allow Orchestrator UI Access" option activated, in order to determine whether it is active for the user or not?

Issue Description: What parameters should be checked in the database and what query should be used to extract the users who have the "Allow Orchestrator UI Access" option activated, in order to determine whether it is active for the user or not?

Resolution:

Editing the Allow Orchestrator UI Access toggle is reflected in the AllowedSessions column in the dbo.Users table.

The entries already present in the table already have a set value in the specified column, depending on their attributes (users, groups, robots, licenses etc.)

  • When disabling the Allow Orchestrator UI Access option, that value is decremented by 1.
  • When enabling the Allow Orchestrator UI Access option, that value is incremented by 1.

Note that currently, It is not possible to provide the requested data and documentation regarding the database structure.

The reason for this is that there is a value in the database that does not conform to the expected format of either 1 or 0. The availability of data is dependent on the user's role, whether they are a Robot, local user, or part of a group, as well as their specific licensing arrangement. The motive is to prevent any unintended modifications to the database that could potentially lead to application issues.


Workaround: Use the UI to check the user settings and permissions. The API would also work in case it is required to do this regularly from a script or automation.