vdsUser
  • 08 Jan 2025
  • 1 Minute à lire
  • Sombre
    Lumière
  • PDF

vdsUser

  • Sombre
    Lumière
  • PDF

The content is currently unavailable in French. You are viewing the default English version.
Résumé de l’article

The vdsUser table contains the attributes of the existing authenticator users.

Columns

Table: vdsUser table columns
Column nameData typePrimary keyNullableDescription
vdsDomainvarchar(255)YesNoThe domain of the user.
vdsUserIdvarchar(255)YesNoThe user ID of the user.
vdsOrgUnitvarchar(255)NoYesThe organizational unit in which the user is located.
vdsUserNamevarchar(1024)NoYesThe full name of the user.
vdsDescriptionvarchar(1024)NoYesAny descriptive text or notes.
vdsPhonevarchar(64)NoYesThe user's landline number.
vdsMobilevarchar(64)NoYesThe user's mobile phone number.
vdsEmailvarchar(255)NoYesThe user's e-mail address.
vdsStaticPwdvarchar(1024)NoYesThis column contains binarydata stored in base64-encoded format.
vdsLinkUserDomainvarchar(255)NoYes 
vdsLinkUserIdvarchar(255)NoYes 
vdsLocalAuthintegerNoYes 
vdsBackEndAuthintegerNoYes 
vdsLockCountintegerNoYes 
vdsLockedintegerNoYes 
vdsDisabledintegerNoYes 
vdsProfilesvarchar(255)NoYesThis column is obsolete(replaced by the separate vdsUserAttr table).
vdsAdminPrivilegesvarchar(1024)NoYesThis column contains binarydata stored in the base64-encoded format.
vdsOfflineAuthEnabledintegerNoYes 
vdsStaticPwdHistoryvarchar(1024)NoYes 
vdsLastPwdSetTimetimestampNoYes 
vdsCreateTimetimestampNoNoThe date and time the data record was created.
vdsModifyTimetimestampNoNoThe date and time the data record was last modified.
vdsKeyIDvarchar(255)NoYes 
vdsLastAuthTimetimestampNoYesThe date and time of the last authentication for the user.
vdsExpirationTimetimestampNoYesThe date and time when the user account can no longer be used for authentication.
vdsVDPDeliveryMethodvarchar(16)NoYesThe delivery method for Virtual Mobile Authenticator messages. This overrides the general delivery method specified in the user policy.
vdsVDPSignDeliveryMethodvarchar(16)NoYesThe delivery method for virtual signature messages. This overrides the general delivery method specified in the user policy.
vdsVDPMDCProfilevarchar(255)NoYesThe Message Delivery Component (MDC) profile for Virtual Mobile Authenticator messages. This overrides the MDC profile specified in the user policy.
vdsVDPSignMDCProfilevarchar(255)NoYesThe Message Delivery Component (MDC) profile for virtual signature messages. This overrides the MDC profile specified in the user policy.
vdsStaticPwdKeyIDvarchar(255)NoYes 
vdsAdminPrivilegesKeyIDvarchar(255)NoYes 
vdsLastAuthReqTimetimestampNoYesThe date and time of the last authentication request for the user.
vdsVersionintegerNoYesThe current data schema version of the data record.
vdsUserInactDaysintegerNoYesIndicates the policy override for the maximum number of days between authentications after which a user will be suspended. 0 effectively disables this feature.
vdsServiceintegerNoNo

If enabled, this setting converts the user into a service user.

Default value: 0

vdsAdminLevelintegerNoNo

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: 0255

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 nameIncluded fields
Level 0 (default)
vdsuseridx

vdsDomain

vdsUserId


Cet article vous a-t-il été utile ?

What's Next
Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
ESC

Ozzy, facilitant la découverte de connaissances grâce à l’intelligence conversationnelle