Hi,
I want to query the PostgreSQL DB to list All Authorized/Non-Authorized State users.
I can't locate the "Authorized State" field in DB tables. That field can by seen in the Admin Web interface under
Admin Tools >Tools > Users & Groups>Users when you surch for a specific user(s)/ generic name string ....
No REST/API, just by using SQL query
Thank you
If you are talking about the Alfresco Enterprise authorised state for users (Community does not have something like this), then you want to look into the alf_auth_status table and its authaction column. Bear in mind that only read-only actions are safe here, as the Alfresco uses encrypted row- and table-level checksums to determine if this table has been messed with manually and will put your system in read-only state if it detects an inconsistent state.
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.