Enum TableAction

(experimental) An action that a Redshift user can be granted privilege to perform on a table.

Namespace: Amazon.CDK.AWS.Redshift.Alpha

Assembly: Amazon.CDK.AWS.Redshift.Alpha.dll

Syntax (csharp)

public enum TableAction

Syntax (vb)

Public Enum TableAction

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.

Fields

Name	Description
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.