REVOKE Data Source Permission

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

REVOKE Data Source Permission Syntax

REVOKE <CONNECT | ADMIN> [PRIVILEGES]
ON <ALL DATA SOURCES [IN [SCHEMA] <schema reference>] | DATA SOURCE <data source reference>>
FROM <user name | role name>

REVOKE Create Data Source Permission Syntax

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

Examples

To revoke connect access on the data source named kin_ds from the auser user:

REVOKE Data Source Use Permission Example

REVOKE CONNECT ON DATA SOURCE kin_ds FROM auser

To revoke administrative access on the data source named kin_ds_anon from the auser user:

REVOKE Data Source Administrative Permission Example

REVOKE ADMIN ON DATA SOURCE kin_ds_anon FROM auser

​Examples

Examples