Administration and Help Desk Views
ActivID AS administration and help desk data is available as a set Oracle views:
Administration
User Permissions
Table name - USERPERMISSIONS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
USERID |
Num(28) |
Unique internal identifier, set implicitly by ActivID AS |
|
USERCODE |
Char(255) |
Unique identifier of the user known to the user |
|
GRANTCHANNELCODE |
Char(10) |
Permission is granted if the authentication is through this channel |
|
GRANTAUTHPOLICY |
Char(10) |
Permission is granted if the authentication is through this authentication policy |
|
PERMISSIONCODE |
Char(10) |
Permission granted to this user |
|
ONUSERGROUPCODE |
Char(100) |
Target group where the permission is allowed |
|
PRIVILEGETYPE |
Char(10) |
Type of permission (ENABLER or BLOCKER) |
|
PARAMETER |
Char (200) |
The optional function parameter |
User External Permissions
Table name - USEREXTPERMISSIONS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
USERID |
Num(28) |
Unique internal identifier, set implicitly by ActivID AS |
|
USERCODE |
Char(255) |
Unique identifier of the user known to the user |
|
GRANTCHANNELCODE |
Char(10) |
Permission is granted if the authentication is through this channel |
|
GRANTAUTHPOLICY |
Char(10) |
Permission is granted if the authentication is through this authentication policy |
|
EXTPERMISSIONCODE |
Char(10) |
External permission granted to this user |
|
PRIVILEGETYPE |
Char(10) |
Type of permission (ENABLER or BLOCKER) |
|
THRESHOLD |
Char (200) |
The threshold the privilege is allowed to. |
User External Permission Sets
Table name - USEREXTPERMISSIONSSETS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
USERID |
Num(28) |
Unique internal identifier, set implicitly by ActivID AS |
|
USERCODE |
Char(255) |
Unique identifier of the user known to the user |
|
GRANTCHANNELCODE |
Char(10) |
Permission is granted if the authentication is through this channel |
|
GRANTAUTHPOLICY |
Char(10) |
Permission is granted if the authentication is through this authentication policy |
|
EXTPERMISSIONSETCODE |
Char(10) |
External permission set granted to this user |
|
PRIVILEGETYPE |
Char(10) |
Type of permission (ENABLER or BLOCKER) |
|
THRESHOLD |
Char (200) |
The threshold to which the privilege is allowed. |
User Groups
Table name - USERGROUP_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
USERGROUPCODE |
Char(100) |
Unique ID of user group |
|
UGNAME |
Char(50) |
Group Name |
|
UGNOTES |
Char(100) |
Group Description |
|
PARENTGROUPCODE |
Char(100) |
Group Id of the parent group of this group. |
|
ALLOWEDAUTHPOLICIES |
Char(variable up to 4000) |
List of Authentication policies allowed by this group membership. (separated by ‘|’) |
Group Permissions
Table name - GROUPPERMISSIONS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
USERGROUPCODE |
Char(100) |
Unique ID of user group |
|
PERMISSIONSET |
Char(10) |
Permission set granted to users members of the group defined by USERGROUPCODE |
|
GRANTCHANNELCODE |
Char(10) |
Permission is granted if the authentication is through this channel |
|
GRANTAUTHPOLICY |
Char(10) |
Permission is granted if the authentication is through this authentication policy |
|
ONUSERGROUPCODE |
Char(100) |
Target group where the permissions are allowed |
|
ISALLONUSERGROUP |
Char(1) |
True if the allowed permission are on all groups (Y=true, N=false) |
|
ASSETGROUPCODE |
Char(20) |
Asset group where the permissions are allowed |
|
ISALLASSETGROUP |
Char(1) |
True if the allowed permission are on all asset groups (Y=true, N=false) |
|
PRIVILEGETYPE |
Char(10) |
Type of permission |
Group External Permissions
Table name - GROUPEXTPERMISSIONS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
USERGROUPCODE |
Char(100) |
Unique ID of user group |
|
EXTPERMISSIONSET |
Char(10) |
External Permission set granted to users members of the group defined by USERGROUPCODE |
|
GRANTCHANNELCODE |
Char(10) |
Permission is granted if the authentication is through this channel |
|
GRANTAUTHPOLICY |
Char(10) |
Permission is granted if the authentication is through this authentication policy |
|
ASSETSETCODE |
Char(20) |
Asset set where the permissions are allowed |
|
ISALLASSETSET |
Char(1) |
True if the allowed permission are on all asset sets (Y=true, N=false) |
|
PRIVILEGETYPE |
Char(10) |
Type of permission (ENABLER or BLOCKER) |
Roles
Table name - ROLES_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
CODE |
Char(20) |
Role unique id |
|
NAME |
Char(50) |
Role name |
|
NOTES |
Char(100) |
Description |
Role Permissions
Table name - ROLEPERMISSIONS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
ROLECODE |
Char(20) |
Unique ID of role |
|
PERMISSIONSET |
Char(10) |
Permission set granted to users having the role defined by ROLECODE |
|
GRANTCHANNELCODE |
Char(10) |
Permission is granted if the authentication is through this channel |
|
GRANTAUTHPOLICY |
Char(10) |
Permission is granted if the authentication is through this authentication policy |
|
ONUSERGROUPCODE |
Char(100) |
Target group where the permissions are allowed |
|
ISALLONUSERGROUP |
Char(1) |
True if the allowed permission are on all groups (Y=true, N=false) |
|
ASSETGROUPCODE |
Chart(20) |
Asset group where the permissions are allowed |
|
ISALLASSETGROUP |
Char(1) |
True if the allowed permission are on all asset groups (Y=true, N=false) |
Role External Permissions
Table name - ROLEEXTPERMISSIONS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
ROLECODE |
Char(100) |
Unique ID of role |
|
EXTPERMISSIONSET |
Char(10) |
External Permission set granted to users members of the group defined by USERGROUPCODE |
|
GRANTCHANNELCODE |
Char(10) |
Permission is granted if the authentication is through this channel |
|
GRANTAUTHPOLICY |
Char(10) |
Permission is granted if the authentication is through this authentication policy |
|
ASSETSETCODE |
Char(20) |
Asset set where the permissions are allowed |
|
ISALLASSETSET |
Char(1) |
True if the allowed permission are on all asset sets (Y=true, N=false) |
Permission Sets
Table name - PERMISSIONSETS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
CODE |
Char(10) |
Permission set unique ID |
|
NAME |
Char(50) |
Permission set Name |
|
RESOURCETYPE |
Char(15) |
None/ ASSETGROUP/GROUP |
|
PERMISSIONS |
Char(variable up to 4000) |
Individuals permissions allowed by this permission set |
External Permissions
Table name - EXTPERMISSIONS
| Name | Data type (Max length) | Description |
|---|---|---|
|
CODE |
Char(10) |
External Permission set unique ID |
|
NAME |
Char(50) |
External Permission set Name |
|
RESOURCETYPE |
Char(15) |
None/ ASSETGROUP/GROUP |
|
PERMISSIONS |
Char(Variable up to 4000) |
Individuals permissions allowed by this external permission set |
Help Desk
Users
Table name - USERS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
USERID |
Num(28) |
Unique internal identifier, set implicitly by ActivID AS |
|
USERCODE |
Char(255) |
Unique identifier of the user known to the user |
|
USERSTATUS |
Char(10) |
The current status of the user (ENABLED/DISABLED) |
|
DATE |
Date |
The date the user was created |
|
USERGROUPCODE |
Char(100) |
The ID of the subgroup to which this user belongs |
|
USERGROUPNAME |
Char(50) |
The name of the subgroup to which this user belongs |
|
LASTDS |
Char(20) |
The last data source the user was found in |
|
LASTKNOWNDN |
Char(300) |
The last full LDAP DN the user was found at |
|
LASTKNOWNSTATUS |
Char(10) |
Last know LDAP user status (ENABLED/DISABLED) |
|
LASTKNOWNROLES |
Char(variable up to 1050) |
Last know user roles based on dynamic LDAP to roles mapping |
|
GUID |
Char(120) |
LDAP UUID/GUID of user object |
|
ROLECODES |
Char(variable up to 4000) |
Roles individually assigned to user |
|
DEVICESID |
Char(variable up to 4000) |
IDs of Devices bound to user |
|
DEVICESSN |
Char(variable up to 4000) |
Devices serial numbers bound to user |
|
AUTHENTICATORS |
Char(variable up to 4000) |
Device authenticators |
|
LOGINAUTHENTICATORS |
Char(variable up to 4000) |
Password credential/authenticators |
|
ATTSV |
Char(variable up to 4000) |
User attributes (DB attributes) |
|
CREDENTIALSCODES |
User credentials |
Credential codes of Credentials bound to user List of Credentials Codes attached to this device (separated by ‘|’) Each list entry has the following format CREDENTIALID = CREDENTIALTYPECODE;CREDENTIALCODE |
Devices
Table name - DEVICES_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
DEVICEID |
Num(28) |
Internal device ID (number) |
|
SERIALNUMBER |
Char(50) |
Device Serial Number, SN is not unique |
|
NAME |
Char(50) |
Device Friendly name |
|
ISSUENUMBER |
Num(28) |
Device issue number , (SN, Issue number) is unique for a given device type |
|
DEVICETYPECODE |
Char(10) |
Device type code - note the label uniqueness is not enforced by the system |
|
DEVICETYPENAME |
Char(50) |
Device type label - note the label uniqueness is not enforced by the system |
|
STARTDATE |
Date |
Device validity start date |
|
MANUFACTURER |
Char(50) |
Manufacturer name as provided at device import time |
|
STATUS |
Char(20) |
Device status (ACTIVE/REVOKED/PENDING…). |
|
REASON |
Char(20) |
The reason for the status |
|
ADDEDDATE |
Date |
Device creation date |
|
STARTDATE |
Date |
Device validity start date |
|
EXPIRYDATE |
Date |
Device validity expiration date |
|
USERID |
Num(28) |
User ID of the user who assigned the device |
|
USERCODE |
Char(255) |
Device owner user name |
|
CREDENTIALSCODES |
Char(variable up to 4000) |
List of Credentials Codes attached to this device (separated by ‘|’) Each list entry has the following format CREDENTIALID = CREDENTIALTYPECODE;CREDENTIALCODE |
Credentials
Table name - CREDENTIALS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
CREDENTIALID |
Num (28) |
Credential internal ID |
|
CREDENTIALCODE |
Char(3000) |
Credential ID |
|
CREDENTIALTYPECODE |
Char(50) |
Type of the credential |
|
CREDENTIALTYPENAME |
Char(50) |
Name of the type of credential |
|
DEVICEID |
Num(28) |
Device holding the credential |
|
DEVICETYPECODE |
Char(10) |
Device type holding the credential |
|
DEVICESERIALNUMBER |
Char(50) |
Device Serial Number, SN is not unique |
|
USERID |
Num(28) |
Internal ID of the User/owner of the credential |
|
USERCODE |
Char(255) |
Name of the User/owner of the credential |
|
ADDEDDATE |
Date |
Credential creation date |
|
LASTMODIFIEDDATE |
Date |
Date of last update of the credential |
|
STARTDATE |
Date |
Credential validity start date |
|
EXPIRYDATE |
Date |
Credential validity expiry date |
|
STATUS |
Char(20) |
Credential status |
|
TOTALUSED |
Num(28) |
Count of times credential has been used |
Authenticators
Table name - AUTHENTICATORS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
AUTHENTICATORID |
Num(28) |
Internal ID of the credential |
|
USERID |
Num(28) |
Internal ID of the User/owner of the credential |
|
USERNAME |
Char(255) |
Name of the User/owner of the credential |
|
AUTHENTICATIONTYPECODE |
Char(10) |
Code of the authentication policy |
|
AUTHENTICATIONTYPENAME |
Char(50) |
Authentication policy name |
|
STATUSCODE |
Char(10) |
The current status of this authenticator |
|
PRIMARYBLOCKEDCHANNELS |
Char(3700) |
Channels for which this Authenticator is invalid – Primary vs secondary |
|
SECONDARYBLOCKEDCHANNELS |
Char(3700) |
Channels for which this Authenticator as a step-up authentication |
|
VALIDFROM |
Date |
Creation date |
|
VALIDTO |
Date |
End of validity date |
|
TOTALFAILEDCOUNT |
Num(28) |
The total number of unsuccessful authentications by the user using this Authenticator |
|
FAILEDAUTHENTICATIONCOUNT |
Num(28) |
The number of consecutive failed authentications by the user using this Authenticator |
|
SUCCESSFULAUTHENTICATIONCOUNT |
Num(28) |
The total number of successful authentications by the user using this Authenticator |
|
SUCCESSFULSINCECHANGE |
Num(28) |
The number of successful consecutive authentications by the user using this Authenticator |
|
LASTSUCCESSFULAUTHDATETIME |
Date |
The date and time of the last successful authentication of the user using this Authenticator |
|
LASTSUCCESSFULAUTHCHANNEL |
Char(10) |
Last channel that the user successfully authenticated on using this Authenticator |
|
LASTUNSUCCESSFULAUTHDATETIME |
Date |
The date and time of the last unsuccessful authentication of the user using this Authenticator |
|
LASTUNSUCCESSFULAUTHCHANNEL |
Char(10) |
Last channel that the user unsuccessfully authenticated on using this Authenticator |
|
MAXUSAGES |
Num(28) |
The maximum allowed consecutive unsuccessful usages of this Authenticator before it becomes blocked |
|
CHALLENGECOUNTER |
Num(28) |
The number of Challenges issued |
|
LASTCHALLENGEID |
Num(28) |
The ID of the last challenge issued |
|
LASTSUCCESSFULDEVICEID |
Num(28) |
The ID of the last device that was successfully used by the user to authenticate with this Authenticator |
|
LASTSUCCESSFULCREDENTIALID |
Num(28) |
The ID of the last credential the user used successfully |
Login Authentication Records
Table name - LOGINAUTHENTICATORS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
AUTHENTICATORID |
Num(28) |
Internal ID of the credential |
|
USERID |
Num(28) |
Internal ID of the User/owner of the credential |
|
USERNAME |
Char(255) |
Name of the User/owner of the credential |
|
USERNAMEALIAS |
Char(255) |
User name alias for this authenticator |
|
AUTHENTICATIONTYPECODE |
Char(10) |
Code of the authentication policy |
|
AUTHENTICATIONTYPENAME |
Char(50) |
Authentication policy name |
|
STATUSCODE |
Char(10) |
The current status of this authenticator |
|
PRIMARYBLOCKEDCHANNELS |
Char(3700) |
Channels for which this Authenticator is invalid – Primary vs secondary |
|
SECONDARYBLOCKEDCHANNELS |
Char(3700) |
Channels for which this Authenticator as a step-up authentication |
|
VALIDFROM |
Date |
Creation date |
|
VALIDTO |
Date |
End of validity date |
|
TOTALFAILEDCOUNT |
Num(28) |
The total number of unsuccessful authentications by the user using this Authenticator |
|
FAILEDAUTHENTICATIONCOUNT |
Num(28) |
The number of consecutive failed authentications by the user using this Authenticator |
|
SUCCESSFULAUTHENTICATIONCOUNT |
Num(28) |
The total number of successful authentications by the user using this Authenticator |
|
SUCCESSFULSINCECHANGE |
Num(28) |
The number of successful consecutive authentications by the user using this Authenticator |
|
LASTSUCCESSFULAUTHDATETIME |
Date |
The date and time of the last successful authentication of the user using this Authenticator |
|
LASTSUCCESSFULAUTHCHANNEL |
Char(10) |
Last channel that the user successfully authenticated on using this Authenticator |
|
LASTUNSUCCESSFULAUTHDATETIME |
Date |
The date and time of the last unsuccessful authentication of the user using this Authenticator |
|
LASTUNSUCCESSFULAUTHCHANNEL |
Char(10) |
Last channel that the user unsuccessfully authenticated on using this Authenticator |
|
EXPIRYTHRESHOLD |
Num(28) |
The maximum allowed consecutive unsuccessful usages of this Authenticator before it becomes blocked |
|
EXPIREDRESETCOUNT |
Num(28) |
The number of times the Authenticator has been unblocked after exceeding EXPIRYTHRESHOLD |
Q&A Authentication Records
Table name - MDAUTHENTICATORS_VIEW
| Name | Data type (Max length) | Description |
|---|---|---|
|
AUTHENTICATORID |
Num(28) |
Internal ID of the credential |
|
USERNAME |
Char(255) |
Name of the User/owner of the credential |
|
AUTHENTICATIONTYPECODE |
Char(10) |
Code of the authentication policy |
|
AUTHENTICATIONTYPENAME |
Char(50) |
Authentication policy name |
|
MDGROUPID |
Num(28) |
ID of a specific set of prompts associated with this authenticator |
|
STATUSCODE |
Char(10) |
The current status of this authenticator |
|
PRIMARYBLOCKEDCHANNELS |
Char(3700) |
Channels for which this Authenticator is invalid – Primary vs secondary |
|
SECONDARYBLOCKEDCHANNELS |
Char(3700) |
Channels for which this Authenticator as a step-up authentication |
|
VALIDFROM |
Date |
Creation date |
|
VALIDTO |
Date |
End of validity date |
|
TOTALFAILEDCOUNT |
Num(28) |
The total number of unsuccessful authentications by the user using this Authenticator |
|
FAILEDAUTHENTICATIONCOUNT |
Num(28) |
The number of consecutive failed authentications by the user using this Authenticator |
|
SUCCESSFULAUTHENTICATIONCOUNT |
Num(28) |
The total number of successful authentications by the user using this Authenticator |
|
SUCCESSFULSINCECHANGE |
Num(28) |
The number of successful consecutive authentications by the user using this Authenticator |
|
LASTSUCCESSFULAUTHDATETIME |
Date |
The date and time of the last successful authentication of the user using this Authenticator |
|
LASTSUCCESSFULAUTHCHANNEL |
Char(10) |
Last channel that the user successfully authenticated on using this Authenticator |
|
LASTUNSUCCESSFULAUTHDATETIME |
Date |
The date and time of the last unsuccessful authentication of the user using this Authenticator |
|
LASTUNSUCCESSFULAUTHCHANNEL |
Char(10) |
Last channel that the user unsuccessfully authenticated on using this Authenticator |
|
MDANSWERS |
Char(4000) |
List of Users answers (separated by ‘|’) Each list entry has the following format <MDPROMPTCODE>=user answer value (MDPROMPTCODE links to MDPROMPTS_VIEW) |
