aitseitz
/ reset_alf_auth_script.sql
Created
November 9, 2021 14:20
— forked from AFaust/reset_alf_auth_script.sql
Reset Alfresco Authorised Users tracking (only meant for fixing errors, i.e. MNT-16663, or false-positive 'manual changes' detection - not to circumvent subscription terms)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- clear all user license states | |
| delete from alf_auth_status; | |
| -- remove old checksum and keystore | |
| -- ns_id = 1 should always be the system model, store_id = 2 always the system store | |
| delete from alf_node_properties where qname_id in ( | |
| select id from alf_qname where ns_id = 1 and local_name in ('keyStore', 'authorizationChecksum') | |
| ) and node_id in ( | |
| select id from alf_node where store_id = 2 | |
| ); |