Showing results for 
Search instead for 
Did you mean: 

how do you find a locked account?

Level 2 Adventurer

how do you find a locked account?

Problem: How do you veriy an account is no longer a locked account?



EDB AS the view DBA_TABLES. It uses a function, edb_get_role_status() to get the account status for the user.


Where would I find a list of locked users in the pg_ tables? 


I see rollockdate in pg_authid but that field is still populated when I unlock an account. 




Re: how do you find a locked account?

Hi Mediis,


Could you clarify what a "locked user" is?  If you are meaning a user who cannot log in via psql or some other client, you'll need to look in rolcanlogin.  This is set via the CONNECT privilege in the GRANT command.  More information can be found at (


Please let me know if you need any further assistance!