pgadmin-org / pgadmin-org/pgadmin4
Show WARNING,DETAIL and HINT message on login
Open
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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.