Unable to run select query in the Amazon RDS PostgreSQL getting permission denied error

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.    
0 answers