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 levelpriv_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