Skip to main content
Version: 2.82.x.x LTS

OATH

The TIDMA_OATH table lists the specific attributes of OATH credentials. It holds the information in which authentication mode OATH credentials work, which hashing algorithm is used, and of how many digits the token consists. The counter/time is also stored in this table.

The TIDMA_OATH table is an extension of the TIDMA_CREDENTIAL, which lists attributes that are valid for all credentials.

Database table TIDMA_OATH

DB attributeJava data type (max. size), defaultsDescription
authentication_method_idLong, not NULLThe ID of the OATH authentication method to use.1: HOTP; 2: TOTP
counterLong, not NULLThe counter for tokens. This is increased on each successful authentication.
credential_idLong, not NULLPrimary key (uniquely identifies each individual credential). Foreign key that links to information in the table TIDMA_CREDENTIAL.
digitsInteger, not NULLThe length of the generated token. Possible options: 6; 7; 8
hashing_algorithm_idLong, not NULLThe ID of the OATH hashing algorithm to use. Possible options: 1: SHA1; 2: SHA256; 3: SHA512
is_sharedBoolean, not nullFlag to make sure the credential is only shared once.
periodLong, not NULLThe time window (in seconds) how long a TOTP token is valid.
time_driftLong, nullableDetected clock drift for the token in terms of the number of time steps.