Mobile Multi-Factor Authentication (MMFA) clean-up

Edit online

When performing cleanup on the OAUTH_AUTHENTICATORS table, entries are deleted when the STATE_ID is not found in the OAUTH20_TOKEN_CACHE.

Manual clean-up queries

To disable the out-of-the-box cleanup set mmfa.authenticator.cleanupWait to 0.

Select the rows to delete with the following queries:
Query 1

SELECT STATE_ID as v1
FROM OAUTH_AUTHENTICATORS
Query 2

SELECT STATE_ID as v2 
FROM OAUTH20_TOKEN_CACHE 
WHERE STATE_ID = v1
Delete rows with the following query:
Note: Deletes must only be performed when v2 is null from the execution of query 2.

DELETE FROM OAUTH_AUTHENTICATORS
WHERE STATE_ID = v1