I have a Postgres instance of version 10 running on AWS RDS. I have a user there with default roles granted to it. I want to create the same user on my sandbox where the instance is of version 9.4. Thus, I want to know the grants that are included in these default roles of version 10.
Postgresql – How to extract the grants on default roles of PostgreSQL 10: pg_read_all_settings, pg_read_all_stats, pg_monitor and pg_signal_backend
postgresqlpostgresql-10
Related Question
- RDS PostgreSQL – Performance Optimization Tips
- RDS Crosstab – Fixing ‘Permission Denied for Language C’ Error
- PostgreSQL – Resolving ‘Alter Default Privileges’ Issue
- Postgresql – postgres: list role grants for all users
- Google Cloud SQL – How to Set Up Vault and Postgres with Correct Permissions
- AWS RDS Postgres – Differences Between First and Subsequent rds_superusers
- Postgresql – How to install tds_fdw on AWS RDS for SQL Server
Best Answer
Have a look at https://www.postgresql.org/docs/current/infoschema-role-table-grants.html
See also https://stackoverflow.com/a/55459289/6368697