Step 2: Create a user - Amazon Redshift

Step 2: Create a user

By default, only the admin user that you created when you launched the data warehouse has access to the default database in the data warehouse. To grant other users access, create one or more accounts. Database user accounts are global across all the databases in a data warehouse, and not per individual database.

Use the CREATE USER command to create a new user. When you create a new user, you specify the name of the new user and a password. We recommend that you specify a password for the user. It must have 8–64 characters, and it must include at least one uppercase letter, one lowercase letter, and one numeral.

For example, to create a user named GUEST with password ABCd4321, run the following command.


To connect to the SALESDB database as the GUEST user, use the same password when you created the user, such as ABCd4321.

For information about other command options, see CREATE USER in the Amazon Redshift Database Developer Guide.