1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
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.
Contenus pertinents
- demandé il y a un an
- demandé il y a 7 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a un an
Thank you very much for your response. I am able to achieve what was required with a small modification in the below statement: instead of this: GRANT ALL ON SCHEMA my_database TO new_user;
I used this: GRANT CREATE ON DATABASE my_schema TO new_user;