title: Amazon RDS Postgres -> Give permission to pg_catalog
body: <p>I need to grant permission to the master user(MasterUsername) the access of of pg_catalog.</p>
  
  <pre><code>GRANT USAGE ON SCHEMA pg_catalog TO &lt;master-user&gt;;
  </code></pre>
  
  <p>On running this, I get the below warning:
  WARNING:  no privileges were granted for "pg_catalog".</p>
  
  <p>Essentially, I have an automation script, where I create the database, I set search path and :</p>
  
  <pre><code>SET search_path = &lt;my-schema&gt;, pg_catalog;
  CREATE TYPE &lt;type&gt; AS (
  id bigint,
  name character varying);
  </code></pre>
  
  <p>I get below error</p>
  
  <pre><code>Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for schema pg_catalog
  </code></pre>
  
  <p>Essentially, it's not allowing me to create type, since the pg_type table exists in pg_catalog. How to create type? </p>
  
  <p>I don't know if granting the USAGE rights will help? If there's another way to work-around this, please do let me know.</p>