The vdsUser table contains the attributes of the existing authenticator users.
Columns
Table: vdsUser table columns| Column name | Data type | Primary key | Nullable | Description |
|---|
| vdsDomain | varchar(255) | Yes | No | The domain of the user. |
| vdsUserId | varchar(255) | Yes | No | The user ID of the user. |
| vdsOrgUnit | varchar(255) | No | Yes | The organizational unit in which the user is located. |
| vdsUserName | varchar(1024) | No | Yes | The full name of the user. |
| vdsDescription | varchar(1024) | No | Yes | Any descriptive text or notes. |
| vdsPhone | varchar(64) | No | Yes | The user's landline number. |
| vdsMobile | varchar(64) | No | Yes | The user's mobile phone number. |
| vdsEmail | varchar(255) | No | Yes | The user's e-mail address. |
| vdsStaticPwd | varchar(1024) | No | Yes | This column contains binarydata stored in base64-encoded format. |
| vdsLinkUserDomain | varchar(255) | No | Yes | |
| vdsLinkUserId | varchar(255) | No | Yes | |
| vdsLocalAuth | integer | No | Yes | |
| vdsBackEndAuth | integer | No | Yes | |
| vdsLockCount | integer | No | Yes | |
| vdsLocked | integer | No | Yes | |
| vdsDisabled | integer | No | Yes | |
| vdsProfiles | varchar(255) | No | Yes | This column is obsolete(replaced by the separate vdsUserAttr table). |
| vdsAdminPrivileges | varchar(1024) | No | Yes | This column contains binarydata stored in the base64-encoded format. |
| vdsOfflineAuthEnabled | integer | No | Yes | |
| vdsStaticPwdHistory | varchar(1024) | No | Yes | |
| vdsLastPwdSetTime | timestamp | No | Yes | |
| vdsCreateTime | timestamp | No | No | The date and time the data record was created. |
| vdsModifyTime | timestamp | No | No | The date and time the data record was last modified. |
| vdsKeyID | varchar(255) | No | Yes | |
| vdsLastAuthTime | timestamp | No | Yes | The date and time of the last authentication for the user. |
| vdsExpirationTime | timestamp | No | Yes | The date and time when the user account can no longer be used for authentication. |
| vdsVDPDeliveryMethod | varchar(16) | No | Yes | The delivery method for Virtual Mobile Authenticator messages. This overrides the general delivery method specified in the user policy. |
| vdsVDPSignDeliveryMethod | varchar(16) | No | Yes | The delivery method for virtual signature messages. This overrides the general delivery method specified in the user policy. |
| vdsVDPMDCProfile | varchar(255) | No | Yes | The Message Delivery Component (MDC) profile for Virtual Mobile Authenticator messages. This overrides the MDC profile specified in the user policy. |
| vdsVDPSignMDCProfile | varchar(255) | No | Yes | The Message Delivery Component (MDC) profile for virtual signature messages. This overrides the MDC profile specified in the user policy. |
| vdsStaticPwdKeyID | varchar(255) | No | Yes | |
| vdsAdminPrivilegesKeyID | varchar(255) | No | Yes | |
| vdsLastAuthReqTime | timestamp | No | Yes | The date and time of the last authentication request for the user. |
| vdsVersion | integer | No | Yes | The current data schema version of the data record. |
| vdsUserInactDays | integer | No | Yes | Indicates the policy override for the maximum number of days between authentications after which a user will be suspended. 0 effectively disables this feature. |
| vdsService | integer | No | No | If enabled, this setting converts the user into a service user. Default value: 0 |
| vdsAdminLevel | integer | No | No | The administrator level of an administrative user account. Lower-level administrators cannot modify or even view administrator accounts with an administrator level higher than their own. It has no effect on non-administrative user accounts. Supported values: 0–255 Default value: 255 The maximum value on OneSpan Authentication Server Appliance is 100. |
Keys
Primary key: (vdsDomain, vdsUserId)
Foreign keys:
- (vdsLinkUserDomain, vdsLinkUserId) references vdsUser (vdsDomain, vdsUserId)
- (vdsDomain) references vdsDomain (vdsDomain)
- (vdsDomain, vdsOrgUnit) references vdsOrgUnit (vdsDomain, vdsOrgUnit)
- (vdsKeyID) references vdsKey (vdsKeyID)
- (vdsStaticPwdKeyID) references vdsKey (vdsKeyID)
- (vdsAdminPrivilegesKeyID) references vdsKey (vdsKeyID)
Indexes
Table: vdsUser table indexes| Index name | Included fields |
|---|
| Level 0 (default) |
| vdsuseridx | vdsDomain vdsUserId |