topic How to query PostgreSQL DB to list Authorized/Non-Authorized State users in Alfresco Forum

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

Kiwi — Wed, 08 Jul 2020 15:53:16 GMT

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

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

afaust — Thu, 09 Jul 2020 07:41:19 GMT

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.