Experimental
@aws-cdk/aws-redshift-alpha is an experimental (alpha) package: its API may change in any release, without a major version bump.
TableAction Enum
An action that a Redshift user can be granted privilege to perform on a table.
Example
ts
const databaseName = 'databaseName';
const username = 'myuser'
const tableName = 'mytable'
const user = new User(this, 'User', {
username: username,
cluster: cluster,
databaseName: databaseName,
});
const table = new Table(this, 'Table', {
tableColumns: [{ name: 'col1', dataType: 'varchar(4)' }, { name: 'col2', dataType: 'float' }],
cluster: cluster,
databaseName: databaseName,
});
table.grant(user, TableAction.INSERT);
python
from aws_cdk.aws_redshift_alpha import Column, Column
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)
java
String databaseName = "databaseName";
String username = "myuser";
String tableName = "mytable";
User user = User.Builder.create(this, "User")
.username(username)
.cluster(cluster)
.databaseName(databaseName)
.build();
Table table = Table.Builder.create(this, "Table")
.tableColumns(List.of(Column.builder().name("col1").dataType("varchar(4)").build(), Column.builder().name("col2").dataType("float").build()))
.cluster(cluster)
.databaseName(databaseName)
.build();
table.grant(user, TableAction.INSERT);
csharp
// Install: dotnet add package Amazon.CDK.AWS.Redshift.Alpha
var databaseName = "databaseName";
var username = "myuser";
var tableName = "mytable";
var user = new User(this, "User", new UserProps {
Username = username,
Cluster = cluster,
DatabaseName = databaseName
});
var table = new Table(this, "Table", new TableProps {
TableColumns = new [] { new Column { Name = "col1", DataType = "varchar(4)" }, new Column { Name = "col2", DataType = "float" } },
Cluster = cluster,
DatabaseName = databaseName
});
table.Grant(user, TableAction.INSERT);
go
// Install: go get github.com/aws/aws-cdk-go/awscdkredshiftalpha/v2
databaseName := "databaseName"
username := "myuser"
tableName := "mytable"
user := awscdkredshiftalpha.NewUser(this, jsii.String("User"), &UserProps{
Username: username,
Cluster: cluster,
DatabaseName: databaseName,
})
table := awscdkredshiftalpha.NewTable(this, jsii.String("Table"), &TableProps{
TableColumns: []Column{
&Column{
Name: jsii.String("col1"),
DataType: jsii.String("varchar(4)"),
},
&Column{
Name: jsii.String("col2"),
DataType: jsii.String("float"),
},
},
Cluster: cluster,
DatabaseName: databaseName,
})
table.grant(user, awscdkredshiftalpha.TableAction_INSERT)
Members
| Member | Description |
|---|---|
SELECT | Grants privilege to select data from a table or view using a SELECT statement. |
INSERT | Grants privilege to load data into a table using an INSERT statement or a COPY statement. |
UPDATE | Grants privilege to update a table column using an UPDATE statement. |
DELETE | Grants privilege to delete a data row from a table. |
DROP | Grants privilege to drop a table. |
REFERENCES | Grants privilege to create a foreign key constraint. |
ALL | Grants all available privileges at once to the specified user or user group. |