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
partof our auditing, I need a script to list down all the privileges of all the users to each database and if any
privilegethat I need is missing, it should automatically execute the grant /revoke (for example account1 should have
onlyselect privileges. If it is granted with anything else it should revoke the permissions and if select is not
grantedit 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