How to query PostgreSQL DB to list Authorized/Non-Authorized State users

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Kiwi

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

afaust

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.