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

cancel
Showing results for 
Search instead for 
Did you mean: 
Member II

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

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

1 Reply
Highlighted
Master

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

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.