Thank you for your suggestions. I want to use pg_cron extension to schedule the
weekly job to capture the privileges of all the databases. I cannot use
node.js as it needs to connect from an EC2 to make the connection. I have do do
everything inside the RDS only.
Sent from my iPhone
> On 17
On 11/16/21 9:07 PM, Prathima Mulpuri wrote:
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
On Tuesday, November 16, 2021, Prathima Mulpuri
wrote:
>
> Please share any ideas and solutions for my requirement.
>
Drop the “function or a stored procedure” requirement, use an external
application language instead. Node.js for example.
Separate the listing of extra/missing privileges from t
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
