Administration and Help Desk Views
ActivID AS administration and help desk data is available as a set Oracle views:
Administration
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 |
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. |
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. |
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 ‘|’) |
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 |
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) |
Name | Data type (Max length) | Description |
---|---|---|
CODE |
Char(20) |
Role unique id |
NAME |
Char(50) |
Role name |
NOTES |
Char(100) |
Description |
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) |
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) |
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 |
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
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 |
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 |
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 |
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 |
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 |
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) |