Menu
Amazon Redshift
Cluster Management Guide (API Version 2012-12-01)

JDBC and ODBC Options for Creating Database User Credentials

To use the Amazon Redshift JDBC or ODBC driver to create database user credentials, provide the database user name as a JDBC or ODBC option. Optionally, you can have the driver create a new database user if one doesn't exist, and you can specify a list of database user groups the user joins at logon.

If you use an identity provider (IdP), work with your IdP administrator to determine the correct values for these options. Your IdP administrator can also configure your IdP to provide these options, in which case you don't need to provide them as JDBC or ODBC options. For more information, see Configure SAML Assertions for Your IdP.

The following table lists the options for creating database user credentials.

Option

Description
DbUser

The name of a database user. If a user named DbUser exists in the database, the temporary user credentials have the same permissions as the existing user. If DbUser doesn't exist in the database and AutoCreate is true, a new user named DbUser is created. Optionally, disable the password for an existing user. For more information, see ALTER_USER

AutoCreate

Specify true to create a database user with the name specified for DbUser if one does not exist. The default is false.

DbGroups A comma-delimited list of the names of existing database groups the database user joins for the current session. By default, the new user is added only to PUBLIC.