Postgresql: handle all queries to change user's password?

Question

I have to log all such queries to my database on Amazon RDS The best way, of course, create a trigger on pg_catalog.pg_authid, but I have no privileges to operate system catalog. Any advice?

Laurenz Albe · Accepted Answer · 2021-06-28 06:40:36Z

0

The best you can do is to set log_statement = 'ddl'. That will log other DDL statements as well.

answered Jun 28, 2021 at 6:40

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql: handle all queries to change user's password?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related