You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

REVOKE

Info

MemSQL Helios does not support this command.

Revoke privileges from a MemSQL user.

Syntax

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

    priv_level:
        *
      | *.*
      | database.*

    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 [, user] ...

Remarks

  • priv_level - privilege level
  • priv_type - privilege type
  • This command can be run on any MemSQL node

Examples

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

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

Related Topics