title: Postgres - Can not 'SELECT' from tables even though my role/user has been granted 'READ'
body: <p>I have an admin role/user and a developers role on postgres. The developers role enherits attributes from a 'readaccess' role which I created for convenience in the future. If I run \du I get:</p>
  
  <pre><code>    Role name    |                         Attributes                         |     Member of     
  -----------------+------------------------------------------------------------+-------------------
   developers      |                                                            | {readaccess}
   rds_replication | Cannot login                                               | {}
   rds_superuser   | Cannot login                                               | {rds_replication}
   rdsadmin        | Superuser, Create role, Create DB, Replication, Bypass RLS+| {}
                   | Password valid until infinity                              | 
   rdsrepladmin    | No inheritance, Cannot login, Replication                  | {}
   readaccess      | Cannot login                                              +| {}
                   | Password valid until infinity                              | 
   admin           | Create role, Create DB                                    +| {rds_superuser}
                   | Password valid until infinity                              | 
  </code></pre>
  
  <p>I have granted read access to my developers account and my readaccess account via the following</p>
  
  <pre><code>GRANT SELECT ON ALL TABLES IN SCHEMA mySchema TO developers;
  ALTER DEFAULT PRIVILEGES IN SCHEMA mySchema GRANT SELECT ON TABLES TO developers;
  
  GRANT SELECT ON ALL TABLES IN SCHEMA mySchema TO readaccess;
  ALTER DEFAULT PRIVILEGES IN SCHEMA mySchema GRANT SELECT ON TABLES TO readaccess;
  </code></pre>
  
  <p>If I run the command \z on one of my tables in mySchema</p>
  
  <pre><code>myDb=&gt; \z mySchema.myTable;
                                           Access privileges
   Schema  |          Name          | Type  |    Access privileges    | Column privileges | Policies 
  ---------+------------------------+-------+-------------------------+-------------------+----------
   mySchema| myTable                | table | admin=arwdDxt/admin+    |                   | 
           |                        |       | developers=r/admin      |                   | 
  (1 row)
  </code></pre>
  
  <p>However I can not run selects -- it says I have no permissions</p>
  
  <pre><code>myDB=&gt; select * from mySchema.myTable;
  ERROR:  permission denied for schema mySchema
  LINE 1: select * from mySchema.myTable;
  </code></pre>
  
  <p>Can anyone help out?</p>