Group Database Privileges

Redshift

If you’re managing a Redshift cluster with many users that have unique responsibilities, you’re going to want to use groups to help manage your cluster's permissions.  A Redshift group is a collection of users.  You can grant permissions on schemas and tables to groups, making permissions management much easier.

Here’s some helpful Redshift documentation about groups:

• CREATE GROUP
• CREATE GROUP <groupname> WITH USER <username1>,<username2>;
• ALTER GROUP - How to add and drop users or rename the group.
• ALTER GROUP <groupname> ADD USER <username>;

Postgres

If you're using a Postgres instance hosted on Platform, you'll want to assign users on the instance to a ROLE. In Postgres, a role can be either a database user or a group of database users, depending on how the role is set up. Like in Redshift, you can grant permissions on objects like schemas and tables to roles, and grant users to a role so that they acquire any permissions associated with the role. Note that the `CREATE GROUP` command in PostgreSQL is an alias for `CREATE ROLE`. The following documentation will be helpful: 

• CREATE ROLE
  • Must have superuser access or CREATEROLE privilege. Contact support@civisanalytics.com if you are having trouble creating a role in your Postgres instance.
• Database Roles