Previous Topic: Used by AuthMinderNext Topic: Used by User Data Service


Used by Administration Console

The following table lists all database tables used by the 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 the Console by using 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 the 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 the Administration Console.

ARADMINCONFIG

Stores the 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 AuthMinder 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 the 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 the Administration Console.

ARADMINSUPPORTEDTIMEZONE

Stores the list of all available time zones.

Note: This is an internal table.

ARADMINTURNEDOFFPRIVILEGE

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

ARADMINTXID

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

ARADMINUITAB

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

ARADMINUITASK

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

ARADMINUITASKATTRIBUTES

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

ARADMINUITASKCONTAINER

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

ARADMINUSER

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

ARADMINUSER_ARCHIVE

Stores the information related to all deleted users.

ARADMINWIZARDTASK

Stores the 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 the 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 CA product-specific information that the Administration Console uses for rendering the Console pages.

ARCMNKEY

Stores the key configurations used while creating or updating organizations.

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 AuthMinder 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 the Administration Console.

ARREPORTTABLES

Stores the information about the reports that are generated using Administration Console.

ARSEQUENCETABLE

Simulates sequences using stored procedures.

Note: This table is used only by MS SQL Server.