How to create a Redshift user with selective schema permissions?

Question

How can I create a new user in Redshift who has SELECT access to all existing schemas, but has full permissions to create and modify their own schemas?

Answer

Create a new user with the desired username using the CREATE USER command, for example:
```
CREATE USER new_user WITH PASSWORD 'password';
```

Grant SELECT access to all existing schemas using the GRANT command, for example:
```
GRANT USAGE ON ALL SCHEMAS IN DATABASE my_database TO new_user;
```

Grant the user full permissions to create and modify their own schemas using the GRANT command, for example:
```
GRANT ALL ON SCHEMA my_schema TO new_user;
```

With these steps, you have created a new Redshift user with SELECT access to all existing schemas and full permissions to create and modify their own schemas.

How to create a Redshift user with selective schema permissions?

相關內容