Unable to run select query in the Amazon RDS PostgreSQL getting permission denied error
0
We are using Amazon RDS PostgreSql for data storage. I am able to connect to the database using console and list all the table, however when I try to run Select query to see the data, it is displaying following error. ERROR: permission denied for relation <tablename> When I list the table, it is having a different owner, which it is dynamically considering based on the application setup. Could you please suggest on to execute the select query in the private cloud hosting setup.