TableAction¶

class aws_cdk.aws_redshift.TableAction(value)¶

Bases: enum.Enum

(experimental) An action that a Redshift user can be granted privilege to perform on a table.

Stability: experimental
ExampleMetadata: fixture=cluster infused

Example:

database_name = "databaseName"
username = "myuser"
table_name = "mytable"

user = User(self, "User",
    username=username,
    cluster=cluster,
    database_name=database_name
)
table = Table(self, "Table",
    table_columns=[Column(name="col1", data_type="varchar(4)"), Column(name="col2", data_type="float")],
    cluster=cluster,
    database_name=database_name
)
table.grant(user, TableAction.INSERT)

Attributes

ALL¶

(experimental) Grants all available privileges at once to the specified user or user group.

Stability: experimental

DELETE¶

(experimental) Grants privilege to delete a data row from a table.

Stability: experimental

DROP¶

(experimental) Grants privilege to drop a table.

Stability: experimental

INSERT¶

(experimental) Grants privilege to load data into a table using an INSERT statement or a COPY statement.

Stability: experimental

REFERENCES¶

(experimental) Grants privilege to create a foreign key constraint.

You need to grant this privilege on both the referenced table and the referencing table; otherwise, the user can’t create the constraint.

Stability: experimental

SELECT¶

(experimental) Grants privilege to select data from a table or view using a SELECT statement.

Stability: experimental

UPDATE¶

(experimental) Grants privilege to update a table column using an UPDATE statement.

Stability: experimental