Hi,
Whenever the postgres user is trying to modify the user account's password column in pg_authid table, we need to maintain a trigger in catalog table (pg_authid) where it pop up the the "password column has been restricted and it should not be modified". Is there any possible for the above scenario in postgres? if it there please guide me how to proceed on this.
and one more question, Can we restrict the postgres user to not modify the pg_authid table. Please share your thoughts on it.
Thanks