Mobile Multi-Factor Authentication (MMFA) clean-up

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: Deletes must only be performed when v2 is null from the execution of query 2.

DELETE FROM OAUTH_AUTHENTICATORS
WHERE STATE_ID = v1

Parent topic: Manual database clean-up