TableAction

class aws_cdk.aws_redshift.TableAction(value)

Bases: 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