Outdated Version

You are viewing an older version of this section. View current production version.

REVOKE

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
Info

MemSQL Developer Edition only allows the creation of new users with root permissions.

Examples

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

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

Related Topics