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. |
|
Copyright © 2013 CA.
All rights reserved.
|
|