Hi all, I need some help regarding Postgres and I have checked and tried many queries. I am working on RDS Postgres 13 and in the process of preparing the script for auditing all the user privileges . As a part of our auditing, I need a script to list down all the privileges of all the users to each database and if any privilege that I need is missing, it should automatically execute the grant /revoke (for example account1 should have only select privileges. If it is granted with anything else it should revoke the permissions and if select is not granted it should grant the select privilege) . This should be done for all the databases in an instance in 1 script. I want to use cursor to list the databases and to run the check and execute queries using a function or a stored procedure. The results of the script should be sent to an email.
Please share any ideas and solutions for my requirement. Thank you Prathima
