Previous Topic: Used by RiskMinderNext Topic: Used by User Data Service (UDS)


Used by Administration Console

The following table lists all database tables that are used by Administration Console.

Table Name

Description

ARADMINAUDITTRAIL

Stores administrator activity audit.

ARADMINAUTHTOKEN

Stores the tokens that Administration Console uses for pluggable authentication.

Every time you log in to Administration Console by using your password, a token is internally generated after password match and stored in this table.

ARADMINBASICAUTHPWDHISTORY

Stores the last n occurrences of password of all administrators in all organizations that use Basic Authentication (for administrators) to log in to Administration Console. This information is stored to prevent password reuse.

ARADMINBASICAUTHUSER

Stores the basic authentication credentials of all administrators in all organizations that use Basic Authentication (for administrators) to log in to Administration Console.

ARADMINCONFIG

Stores Administration Console configurations.

ARADMINCUSTOMROLE

Stores the configurations for all custom-defined roles.

ARADMINMANAGEROLE

Stores the list of roles that a specified role can manage.

ARADMINMAP

Stores the information of the RiskMinder Server instance, which is entered as a key-value pair.

ARADMINPAFCONFIG

Stores the authentication configurations for all administrators in all organizations in the system.

ARADMINPREDEFINEDROLE

Stores the role information for all supported administrators.

ARADMINPWDPOLICY

Stores the details of password policies for all administrators in all organizations.

ARADMINROLEPRIVILEGE

Stores the mapping of all administrative actions (or tasks) supported by Administration Console, the scope of each task, and which role can perform the task.

ARADMINSCOPE

Stores the list of organizations over which each administrator has control (scope).

ARADMINSCOPEALL

Stores the list of all administrators who have control (scope) over all the existing organizations in the system.

ARADMINSUPPORTEDAUTHMECH

Stores the information about all supported authentication mechanisms to log in to Administration Console.

ARADMINSUPPORTEDTIMEZONE

Stores the list of all available time zones that do not change after you install RiskMinder or any other dependent product.

Note: This table is an internal table.

ARADMINTURNEDOFFPRIVILEGE

Stores the list of all privileges that are not available for the given custom role.

ARADMINTXID

Stores information required to generate a unique ID for each transaction.

ARADMINUITAB

Stores information about the tabs that are available and the order in which they are available in Administration Console.

ARADMINUITASK

Stores information about all the tasks that are available and the order in which they are available through Administration Console.

ARADMINUITASKATTRIBUTES

Stores details of the tasks that are displayed, when the first-level and the second-level tabs in Administration Console are clicked. These tasks are referred to as landing pages.

ARADMINUITASKCONTAINER

Stores information related to available task containers. A task container can either be a second-level tab ID or the task group in Administration Console.

ARADMINUSER

Stores detailed information (such as organization to which they belong, current status, timezone, locale, last login time) of all existing administrators.

ARADMINUSER_ARCHIVE

Stores information related to all deleted users.

ARADMINWIZARDTASK

Stores information about all the tasks that can be performed by using the Bootstrap Wizard.

ARCMNBULKOPERATION

Stores information related to all supported bulk operations that include uploading users and uploading user accounts.

ARCMNBULKOPERATIONATTRIBUTE

Stores attributes for all bulk operations in  the ARCMNBULKOPERATION table.

ARCMNBULKREQUEST

Stores details (such as organization name, Request ID, status of the request, data uploaded, and operation) for each bulk-upload request.

ARCMNBULKTASKPARAM

Stores the name and the value of each attribute for each task supported in the system.

ARCMNBULKUPLOADTASK

Stores the status of each task for every bulk-upload request.

ARCMNCACHEREFRESH

Stores cache-related housekeeping information that indicates whether Administration Console needs to be refreshed or not.

ARCMNCONFIG

Stores common Administration Console configuration information. Some of these include whether Bootstrap is complete, whether the cache refresh is automatic or manual, whether attribute encryption is enabled, and whether the bulk upload feature is enabled or not.

ARCMNDBERRORCODES

Stores vendor-specific database error codes and SQL state values that signify whether the database is down or non-responsive. This information is used by the system to decide if database should be failed over, in case a backup database is configured.

ARCMNMAPDATATYPE

Stores RiskMinder-specific information or its dependent products' information that Administration Console uses for rendering the console pages.

ARPFCMNCACHEREFRESHEVENT

Stores details of all cache refresh events for all instances in the system.

ARPFCMNCACHEREFRESHSCOPE

Stores information about all organizations that will be affected if a server cache refresh event occurs.

ARPFCMNCACHEREFRESHSTATUS

Stores the status of each cache refresh event for every instance for which it was triggered.

ARPFCMNINSTANCE

Stores detailed information for all RiskMinder Server instances configured in the system. This also includes the last time the instance was refreshed.

ARPFCMNORGCONFIGDATA

Stores configuration details for each organization. This includes global configurations that can be, typically, overridden at the organization-level.

ARPFCMNORGCONFIGSTATE

Stores the status of each assigned configuration from the ARPFCMNORGCONFIGDATA table.

ARPFCMNPRIVILEGEMAPPING

Stores the details of each privilege available through Administration Console.

ARSEQUENCETABLE

Used only by MS SQL Server, this table simulates sequences using stored procedures.

ARREPORTTABLES

Contains the metadata of other Administration Console and UDS tables.