TableAction
- class aws_cdk.aws_redshift_alpha.TableAction(value, names=None, *, module=None, qualname=None, type=None, start=1, boundary=None)
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