codekingpro/portable-devtools
114k
1��&. �sphinx.addnodes��document���)��}�(� rawsource�� ��children�]�(�docutils.nodes��target���)��}�(h�.. _restore_locked_user:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��restore-locked-user�u�tagname�h3�line�K�parent�h� _document�h�source��nD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\restore_locked_user.rst�ubh �section���)��}�(hhh]�(h �title���)��}�(h�`Lock/Restore Account`:index:�h]�(h �index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��Lock/Restore Account��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh �Text����Lock/Restore Account�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh � paragraph���)��}�(h�5Account locking/unlocking via user management dialog:�h]�hJ�5Account locking/unlocking via user management dialog:�����}�(h hWh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhV)��}�(hX( An admin can lock and unlock user from the user management dialog. This allows the admin to lock or restore5the user when there are several failed login attempts. This page guides you through configuring per-user6locking/restoring. For more details visit :ref:`User management <user_management>`.�h]�(hJ��An admin can lock and unlock user from the user management dialog. This allows the admin to lock or restore7the user when there are several failed login attempts. This page guides you through configuring per-user8locking/restoring. For more details visit �����}�(h heh!hh"NhNubh �pending_xref���)��}�(h�(:ref:`User management <user_management>`�h]�h �inline���)��}�(hhqh]�hJ�User management�����}�(h huh!hh"NhNubah}�(h]�h]�(�xref��std��std-ref�eh]�h]�h]�uhhsh houbah}�(h]�h]�h]�h]�h]��refdoc��restore_locked_user�� refdomain�h��reftype��ref��refexplicit���refwarn��� reftarget��user_management�uhhmh"h#hK h heubhJ�.�����}�(h heh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK h h&h!hubh �table���)��}�(hhh]�h �tgroup���)��}�(hhh]�(h �colspec���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�K#uhh�h h�ubh�)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�K7uhh�h h�ubh �thead���)��}�(hhh]�h �row���)��}�(hhh]�(h �entry���)��}�(hhh]�hV)��}�(h�
**Parameter**�h]�h �strong���)��}�(hh�h]�hJ� Parameter�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh�h h�ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h�ubah}�(h]�h]�h]�h]�h]�uhh�h h�ubh�)��}�(hhh]�hV)��}�(h�**Description**�h]�h�)��}�(hh�h]�hJ�Description�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh�h h�ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h�ubah}�(h]�h]�h]�h]�h]�uhh�h h�ubeh}�(h]�h]�h]�h]�h]�uhh�h h�ubah}�(h]�h]�h]�h]�h]�uhh�h h�ubh �tbody���)��}�(hhh]�h�)��}�(hhh]�(h�)��}�(hhh]�hV)��}�(h�MAX_LOGIN_ATTEMPTS�h]�hJ�MAX_LOGIN_ATTEMPTS�����}�(h j# h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j ubah}�(h]�h]�h]�h]�h]�uhh�h j ubh�)��}�(hhh]�hV)��}�(h��Which sets the number of failed login that9are allowed. If this value is exceeded, the account is locked and can be reset by an administrator.10By setting the variable to the value zero this feature is deactivated.�h]�hJ��Which sets the number of failed login that11are allowed. If this value is exceeded, the account is locked and can be reset by an administrator.12By setting the variable to the value zero this feature is deactivated.�����}�(h j: h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j7 ubah}�(h]�h]�h]�h]�h]�uhh�h j ubeh}�(h]�h]�h]�h]�h]�uhh�h j ubah}�(h]�h]�h]�h]�h]�uhj h h�ubeh}�(h]�h]�h]�h]�h]��cols�Kuhh�h h�ubah}�(h]�h]�(�colwidths-given�� longtable�eh]�h]�h]�uhh�h h&h!hh"h#hNubhV)��}�(h�WWhen Administrator itself gets locked, following steps may be considered to restore it:�h]�hJ�WWhen Administrator itself gets locked, following steps may be considered to restore it:�����}�(h ji h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh �bullet_list���)��}�(hhh]�h � list_item���)��}�(h�SIncrease MAX_LOGIN_ATTEMPTS, and try to successfully login to restore the account.13�h]�hV)��}�(h�RIncrease MAX_LOGIN_ATTEMPTS, and try to successfully login to restore the account.�h]�hJ�RIncrease MAX_LOGIN_ATTEMPTS, and try to successfully login to restore the account.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j~ ubah}�(h]�h]�h]�h]�h]�uhj| h"h#hKh jy h!hubah}�(h]�h]�h]�h]�h]��bullet��-�uhjw h"h#hKh h&h!hubhV)��}�(h�OR�h]�hJ�OR�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhV)��}�(h�"By updating configuration database�h]�hJ�"By updating configuration database�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhV)��}�(h�SQLite DB (pgAdmin4.db):�h]�hJ�SQLite DB (pgAdmin4.db):�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubjx )��}�(hhh]�(j} )��}�(h�WLocate the pgAdmin4.db file and open it using any DB Browser (or DB Browser for SQLite)�h]�hV)��}�(hj� h]�hJ�WLocate the pgAdmin4.db file and open it using any DB Browser (or DB Browser for SQLite)�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK!h j� ubah}�(h]�h]�h]�h]�h]�uhj| h"h#hK!h j� h!hubj} )��}�(h�>After opening the DB file, head towards 'Execute SQL' section.�h]�hV)��}�(hj� h]�hJ�BAfter opening the DB file, head towards ‘Execute SQL’ section.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK"h j� ubah}�(h]�h]�h]�h]�h]�uhj| h"h#hK"h j� h!hubj} )��}�(h�Run below query -14�h]�hV)��}�(h�Run below query -�h]�hJ�Run below query -�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK#h j� ubah}�(h]�h]�h]�h]�h]�uhj| h"h#hK#h j� h!hubeh}�(h]�h]�h]�h]�h]�j� �*�uhjw h"h#hK!h h&h!hubhV)��}�(h�U*UPDATE USER SET LOCKED = false, LOGIN_ATTEMPTS = 0 WHERE USERNAME = <YOUR_EMAIL_ID>*�h]�h �emphasis���)��}�(hj h]�hJ�SUPDATE USER SET LOCKED = false, LOGIN_ATTEMPTS = 0 WHERE USERNAME = <YOUR_EMAIL_ID>�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj h j ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK%h h&h!hubhV)��}�(h�External database:�h]�hJ�External database:�����}�(h j1 h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h h&h!hubjx )��}�(hhh]�(j} )��}�(h�Connect to the database.�h]�hV)��}�(hjD h]�hJ�Connect to the database.�����}�(h jF h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK)h jB ubah}�(h]�h]�h]�h]�h]�uhj| h"h#hK)h j? h!hubj} )��}�(h�Run below query -15�h]�hV)��}�(h�Run below query -�h]�hJ�Run below query -�����}�(h j] h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK*h jY ubah}�(h]�h]�h]�h]�h]�uhj| h"h#hK*h j? h!hubeh}�(h]�h]�h]�h]�h]�j� j uhjw h"h#hK)h h&h!hubhV)��}�(h�U*UPDATE USER SET LOCKED = false, LOGIN_ATTEMPTS = 0 WHERE USERNAME = <YOUR_EMAIL_ID>*�h]�j )��}�(hjy h]�hJ�SUPDATE USER SET LOCKED = false, LOGIN_ATTEMPTS = 0 WHERE USERNAME = <YOUR_EMAIL_ID>�����}�(h j{ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj h jw ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK,h h&h!hubjx )��}�(hhh]�j} )��}�(h�+Make sure the query changes are committed.16�h]�hV)��}�(h�*Make sure the query changes are committed.�h]�hJ�*Make sure the query changes are committed.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK.h j� ubah}�(h]�h]�h]�h]�h]�uhj| h"h#hK.h j� h!hubah}�(h]�h]�h]�h]�h]�j� j uhjw h"h#hK.h h&h!hubhV)��}�(h�)Account locking by failed login attempts:�h]�hJ�)Account locking by failed login attempts:�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK0h h&h!hubh �image���)��}�(h�l.. image:: images/login_attempt_user.png17 :alt: Failed login attempt for current user18 :align: center19�h]�h}�(h]�h]�h]�h]�h]��alt��%Failed login attempt for current user��align��center��uri��images/login_attempt_user.png��20candidates�}�j j� suhj� h"h#hK2h h&h!hubhV)��}�(h�ypgAdmin application is configured to lock a user account when a number of consecutive failed login attempts are21exceeded.�h]�hJ�ypgAdmin application is configured to lock a user account when a number of consecutive failed login attempts are22exceeded.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK6h h&h!hubhV)��}�(h�jMAX_LOGIN_ATTEMPTS is defaulted to 3 unsuccessful login attempts, after which the account would be locked.�h]�hJ�jMAX_LOGIN_ATTEMPTS is defaulted to 3 unsuccessful login attempts, after which the account would be locked.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK9h h&h!hubhV)��}�(h�aThe only way to restore the user account is by contacting the Administrator and ask to unlock it.�h]�hJ�aThe only way to restore the user account is by contacting the Administrator and ask to unlock it.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK;h h&h!hubeh}�(h]�(�lock-restore-account�heh]�h]�(�lock/restore account��restore_locked_user�eh]�h]�uhh$h hh!hh"h#hK�expect_referenced_by_name�}�j hs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K �23translated�K uuhh�current_source�N�current_line�N�settings��docutils.frontend��Values���)��}�(�output�Nh)N� generator�N� datestamp�N�root_prefix��/��source_link�N�24source_url�N�
toc_backlinks�hȌfootnote_backlinks���
sectnum_xform���strip_comments�N�strip_elements_with_classes�N�
strip_classes�N�report_level�K�25halt_level�K�exit_status_level�K�debug�N�warning_stream�N� traceback���input_encoding�� utf-8-sig��input_encoding_error_handler��strict��output_encoding��utf-8��output_encoding_error_handler�j1 �error_encoding��cp1252��error_encoding_error_handler��backslashreplace��
language_code��en��record_dependencies�N�config�N� id_prefix�h�auto_id_prefix��id��
dump_settings�N�dump_internals�N�dump_transforms�N�dump_pseudo_xml�N�expose_internals�N�strict_visitor�N�_disable_config�N�_source�h#�_destination�N�
_config_files�]��file_insertion_enabled���raw_enabled�K�line_length_limit�M'�pep_references�N�pep_base_url��https://peps.python.org/��pep_file_url_template��pep-%04d��rfc_references�N�rfc_base_url��&https://datatracker.ietf.org/doc/html/�� tab_width�K�trim_footnote_reference_space���syntax_highlight��long��smart_quotes���smartquotes_locales�]��character_level_inline_markup���doctitle_xform���
docinfo_xform���sectsubtitle_xform���
image_loading��link��embed_stylesheet���cloak_email_addresses���section_self_link���env�Nub�reporter�N�indirect_targets�]��substitution_defs�}��substitution_names�}��refnames�}��refids�}�h]�has�nameids�}�(j hj j� u� nametypes�}�(j �j �uh}�(hh&j� h&u�
footnote_refs�}��
citation_refs�}��
autofootnotes�]��autofootnote_refs�]��symbol_footnotes�]��symbol_footnote_refs�]�� footnotes�]�� citations�]��autofootnote_start�K�symbol_footnote_start�K �26id_counter��collections��Counter���}���R��parse_messages�]��transform_messages�]�(h �system_message���)��}�(hhh]�hV)��}�(hhh]�hJ�9Hyperlink target "restore-locked-user" is not referenced.�����}�h j� sbah}�(h]�h]�h]�h]�h]�uhhUh j� ubah}�(h]�h]�h]�h]�h]��level�K�type��INFO��source�h#�line�Kuhj� ubj� )��}�(hhh]�hV)��}�(hhh]�hJ�-Hyperlink target "index-0" is not referenced.�����}�h j� sbah}�(h]�h]�h]�h]�h]�uhhUh j� ubah}�(h]�h]�h]�h]�h]��level�K�type�j� �source�h#�line�Kuhj� ube�transformer�N�include_log�]��27decoration�Nh!hub.