REVOKE

Revoke privileges from a MemSQL user.

    REVOKE priv_type ON priv_level
        FROM user ...

    priv_level:
        *
      | *.*
      | database.*

    priv_type:
        SELECT                  
      | INSERT                  
      | UPDATE                  
      | DELETE                  
      | CREATE                  
      | DROP                    
      | REFERENCES              
      | ALTER                   
      | SHOW DATABASES          
      | SUPER                   
      | LOCK TABLES             
      | REPLICATION       
      | CREATE USER             

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

Notes:

• 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'@'%';

Was this Article Helpful?

Thanks For Your Feedback!