title: How to find out what are the privileges granted to a specific group in redshift
body: <p>I am using amazon AWS Redshift (8.0.2 version). I have created a group, granted the 2 permissions below, and added one user to that group.</p>
  <p>If I check <code>pg_group</code>, I can see the users who are members of this group.
  But I would also like to see the permissions granted to that group.</p>
  <p>For e.g.</p>
  <pre><code>redshift=# create group group1;
  CREATE GROUP
  
  redshift=# grant select on public.table_mar19_test2 to group group1;
  GRANT
  
  redshift=# alter group group1 add user user001;
  ALTER GROUP
  
  redshift=# select * from pg_group
  
      groname    | grosysid |  grolist
  ---------------+----------+-----------
   group1        |      101 | {148}
   (1 rows)
  </code></pre>
  <p>Is there any sql query to find out the <code>select</code> grant that was given to this group? Multiple grants from multiple databases are granted to one single group and I would like to see which grant is from which database in the cluster.</p>