Class TableAction
(experimental) An action that a Redshift user can be granted privilege to perform on a table.
Inheritance
Namespace: Amazon.CDK.AWS.Redshift
Assembly: Amazon.CDK.AWS.Redshift.dll
Syntax (csharp)
public sealed class TableAction : Enum
Syntax (vb)
Public NotInheritable Class TableAction
Inherits
Enum
Remarks
Stability: Experimental
ExampleMetadata: fixture=cluster infused
Examples
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);
Synopsis
Fields
ALL | (experimental) Grants all available privileges at once to the specified user or user group. |
DELETE | (experimental) Grants privilege to delete a data row from a table. |
DROP | (experimental) Grants privilege to drop a table. |
INSERT | (experimental) Grants privilege to load data into a table using an INSERT statement or a COPY statement. |
REFERENCES | (experimental) Grants privilege to create a foreign key constraint. |
SELECT | (experimental) Grants privilege to select data from a table or view using a SELECT statement. |
UPDATE | (experimental) Grants privilege to update a table column using an UPDATE statement. |
value__ |
Fields
ALL
(experimental) Grants all available privileges at once to the specified user or user group.
public const TableAction ALL
Field Value
Type | Description |
---|---|
TableAction |
Remarks
Stability: Experimental
DELETE
(experimental) Grants privilege to delete a data row from a table.
public const TableAction DELETE
Field Value
Type | Description |
---|---|
TableAction |
Remarks
Stability: Experimental
DROP
(experimental) Grants privilege to drop a table.
public const TableAction DROP
Field Value
Type | Description |
---|---|
TableAction |
Remarks
Stability: Experimental
INSERT
(experimental) Grants privilege to load data into a table using an INSERT statement or a COPY statement.
public const TableAction INSERT
Field Value
Type | Description |
---|---|
TableAction |
Remarks
Stability: Experimental
REFERENCES
(experimental) Grants privilege to create a foreign key constraint.
public const TableAction REFERENCES
Field Value
Type | Description |
---|---|
TableAction |
Remarks
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.
public const TableAction SELECT
Field Value
Type | Description |
---|---|
TableAction |
Remarks
Stability: Experimental
UPDATE
(experimental) Grants privilege to update a table column using an UPDATE statement.
public const TableAction UPDATE
Field Value
Type | Description |
---|---|
TableAction |
Remarks
Stability: Experimental
value__
public int value__
Field Value
Type | Description |
---|---|
System.Int32 |