Configuring Your Amazon Redshift Data Warehouse Environment
Redshift cluster using one of the following methods:
Method 1: Using PSQL
You can leverage the PostgreSQL… TABLES TO group {{groupname}};
To grant privileges on particular, you can get a few examples from Postgresql