On 6/24/24 03:29, arun chirappurath wrote:
Hi all
I am using rds postgres 14. I have created few users and added them to
pg_readall_data and pg_write_alldata groups
They are able to read all data and do update in tables
However they can't execute functions and not able to script out objects
from pg_admin
The above are two separate issues. Provide examples of what you are
doing and the errors you get when you do them.
Any other role to be added?
You probably should take a look at:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Roles.html#Appendix.PostgreSQL.CommonDBATasks.Access
Thanks,
Arun
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
