pgadmin-org / pgadmin-org/pgadmin4

Show WARNING,DETAIL and HINT message on login

Open
#8,093 8 comments 0 reactions 1 assignee View on GitHub

Nobody has claimed this yet.

Feature
Dominant language
Python
Stars
3.8k
Forks
891
Avg merge
4d 7h
Merged PRs (30d)
8

Description

A customer want to use password profiles with EPAS with PASSWORD_GRACE_TIME parameter.
It works fine but they will need in pgAdmin or other SQL editors a message with the WARNING, DETAIL and HINT message displayed in psql. Currently pgAdmin does not show any message on login to warn the user that he has to change the key. This is the profile that I’m testing:

CREATE PROFILE pwd_profile LIMIT
       PASSWORD_LOCK_TIME 1
       FAILED_LOGIN_ATTEMPTS 5
       PASSWORD_REUSE_TIME 365 
       PASSWORD_LIFE_TIME 0.00011 
       PASSWORD_GRACE_TIME 1;

CREATE ROLE test_user WITH LOGIN PASSWORD 'Thisisapassword1!' PROFILE pwd_profile;

And this this the psql message:

psql -h localhost -p 5444 -U test_user postgres
WARNING:  the account will expire soon; please change your password
DETAIL:  Your password will expire in 0.975414 days.
HINT:  Use ALTER ROLE to change your password.
psql (16.2, server 15.8.1)
Type "help" for help.

postgres=> 

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.