Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

REVOKE

Info

SingleStore Managed Service does not support this command.

Revoke privileges from a SingleStore DB user or role.

Syntax

    REVOKE priv_type [, priv_type] ... ON priv_level
        FROM user_or_role [, user_or_role [ ... ]] ...

    priv_level:
        *
      | *.*
      | database.*

    user_or_role:
      user [, user]
      | role

    user:
      'user_name'@'host_name'

    role:
      ROLE 'role_name'

    priv_type:
    	SELECT
      | INSERT
      | UPDATE
      | DELETE
      | CREATE
      | DROP
      | RELOAD
      | PROCESS
      | FILE READ
      | FILE WRITE
      | GRANT OPTION
      | INDEX
      | ALTER
      | SHOW METADATA
      | SUPER
      | CREATE TEMPORARY TABLES
      | LOCK TABLES
      | REPLICATION
      | CREATE VIEW
      | SHOW VIEW
      | CREATE USER
      | CLUSTER
      | ALTER VIEW
      | DROP VIEW
      | BACKUP
      | CREATE DATABASE
      | DROP DATABASE            

    REVOKE ALL PRIVILEGES, GRANT OPTION
        FROM user_or_role [, user_or_role] ...

Remarks

  • priv_level - privilege level
  • priv_type - privilege type
  • This command can be run on any SingleStore node
  • GRANT OPTION must be revoked separately from any other privileges

Examples

REVOKE INSERT ON *.* FROM 'user'@'%';

REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'%';

REVOKE SELECT ON dbTable FROM ROLE 'r1';

Related Topics