Skip to content

/AWS1/CL_RSHCLUSTERCREDENTIALS

Temporary credentials with authorization to log on to an Amazon Redshift database.

CONSTRUCTOR

IMPORTING

Optional arguments:

iv_dbuser TYPE /AWS1/RSHSTRING /AWS1/RSHSTRING

A database user name that is authorized to log on to the database DbName using the password DbPassword. If the specified DbUser exists in the database, the new user name has the same database permissions as the the user named in DbUser. By default, the user is added to PUBLIC. If the DbGroups parameter is specifed, DbUser is added to the listed groups for any sessions created using these credentials.

iv_dbpassword TYPE /AWS1/RSHSENSITIVESTRING /AWS1/RSHSENSITIVESTRING

A temporary password that authorizes the user name returned by DbUser to log on to the database DbName.

iv_expiration TYPE /AWS1/RSHTSTAMP /AWS1/RSHTSTAMP

The date and time the password in DbPassword expires.

Queryable Attributes

DbUser

A database user name that is authorized to log on to the database DbName using the password DbPassword. If the specified DbUser exists in the database, the new user name has the same database permissions as the the user named in DbUser. By default, the user is added to PUBLIC. If the DbGroups parameter is specifed, DbUser is added to the listed groups for any sessions created using these credentials.

Accessible with the following methods

Method Description
GET_DBUSER() Getter for DBUSER, with configurable default
ASK_DBUSER() Getter for DBUSER w/ exceptions if field has no value
HAS_DBUSER() Determine if DBUSER has a value

DbPassword

A temporary password that authorizes the user name returned by DbUser to log on to the database DbName.

Accessible with the following methods

Method Description
GET_DBPASSWORD() Getter for DBPASSWORD, with configurable default
ASK_DBPASSWORD() Getter for DBPASSWORD w/ exceptions if field has no value
HAS_DBPASSWORD() Determine if DBPASSWORD has a value

Expiration

The date and time the password in DbPassword expires.

Accessible with the following methods

Method Description
GET_EXPIRATION() Getter for EXPIRATION, with configurable default
ASK_EXPIRATION() Getter for EXPIRATION w/ exceptions if field has no value
HAS_EXPIRATION() Determine if EXPIRATION has a value