Skip to content
v2.277.0

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 ​

MemberDescription
SELECTGrants privilege to select data from a table or view using a SELECT statement.
INSERTGrants privilege to load data into a table using an INSERT statement or a COPY statement.
UPDATEGrants privilege to update a table column using an UPDATE statement.
DELETEGrants privilege to delete a data row from a table.
DROPGrants privilege to drop a table.
REFERENCESGrants privilege to create a foreign key constraint.
ALLGrants all available privileges at once to the specified user or user group.