title: How to find the privileges granted to a user in AWS Redshift?
body: <p>I am using a Redshift cluster.</p>
  <p>Version:</p>
  <pre><code>PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.735
  </code></pre>
  <p>I just need to drop a user but it gives the following error message:</p>
  <pre><code>redshiftpocdb=# drop user test_55;
  ERROR:  user &quot;test_55&quot; cannot be dropped because the user has a privilege on some object
  </code></pre>
  <p>Here is the output of the <code>\dp</code> command:</p>
  <pre><code>redshiftpocdb=# \dp
                Access privileges
   schema |  name   | type  | access privileges
  --------+---------+-------+-------------------
   public | company | table |
   public | test2   | table |
   public | test22  | table |
   public | test222 | table |
   public | v_date  | table |
  (5 rows)
  </code></pre>
  <p>In a Postgresql environment, we have the command <code>DROP OWNED BY</code> but it does not work in Redshift.</p>
  <p>How can I find out what privileges were granted to the <code>TEST_55</code> user? Is there any system view we can query ( for e..g in Oracle, we have DBA_ROLE_PRIVS, DBA_TAB_PRIVS...DBA_SYS_PRIVS .etc )?</p>