title: Amazon RDS - Postgresql database owner can't access database after DB engine upgrade
body: <p>After upgrading from postgresql 9.6 to 10.1-R1, the user do not have access to tables.</p>
  
  <p>after investigation, I found the exact same issue on that <a href="http://:%20https://stackoverflow.com/questions/7758533/postgresql-database-owner-cant-access-database-no-relations-found/7758860#7758860" rel="nofollow noreferrer">post</a></p>
  
  <p>When I look at my access privileges, it is empty:</p>
  
  <pre><code>\dn+
                          List of schemas
    Name  |  Owner   | Access privileges |      Description
  --------+----------+-------------------+------------------------
   public | rdsadmin |                   | standard public schema
  </code></pre>
  
  <p>When it should be <code>postgres=UC/postgres=UC/postgres</code></p>
  
  <p>It was correctly set before migration</p>
  
  <p>the recommendation was to run the command <code>grant all on schema public to &lt;my user&gt;;</code> but I don't have enough permission with RDS. Any recomendation to handle this with RDS?</p>