Description:

I’ve created 2 databases in Redshift engine:

• database_production
• database_development

Each database have 2 schemas: public and custom.

Problem:

I want to create user called developer who has all privileges in database_development database but can’t connect and modify any schema in database_production.

Question:

How to create developer users and grand/revoke desired permissions on database_development only?