A company uses an Amazon Redshift cluster as a data warehouse that is shared across...

Group tables and views for each department into dedicated schemas. Manage permissions at the schema level.

Group tables and views for each department into dedicated databases. Manage permissions at the database level.

Update the names of the tables and views to follow a naming convention that contains the department names. Manage permissions based on the new naming convention.

Create an IAM user group for each department. Use identity-based IAM policies to grant table and view permissions based on the IAM user group.