REVOKE Data Sink Permission

Permissions on data sinks that have been granted directly to users or roles can be revoked.

REVOKE Data Sink Permission Syntax

REVOKE <CONNECT | ADMIN> [PRIVILEGES]
ON <ALL DATA SINKS [IN [SCHEMA] <schema reference>] | DATA SINK <data sink reference>>
FROM <user name | role name>

REVOKE Create Data Sink Permission Syntax

REVOKE CREATE [PRIVILEGES] ON DATA SINKS
[IN [SCHEMA] <schema reference>]
FROM <user name | role name>

Examples

To revoke connect access on the data sink named kin_dsink from the auser user:

REVOKE Data Sink Use Permission Example

REVOKE CONNECT ON DATA SINK kin_dsink FROM auser

To revoke administrative access on the data sink named kin_dsink_http from the auser user:

REVOKE Data Sink Administrative Permission Example

REVOKE ADMIN ON DATA SINK kin_dsink_http FROM auser

​Examples

Examples