REVOKE PRIVILEGE

Syntax

REVOKE PRIVILEGE privilege_name ROLE role_name [DATABASE database_name] [TABLE table_name]

Privileges

USERADMIN

Description

Use this command to revoke a privilege (or a command-separated list of privileges) from the ROLE role_name. You can further restrict this command by specifying a database and/or a table name.

Return

OK string or error value (see SCSP protocol).

Example

> REVOKE PRIVILEGE privilege1 ROLE role1
OK