回收权限命令:
--回收建表、改表、删表权限
REVOKE CREATE ON zplatdb.* FROM 'test';
REVOKE DROP ON zplatdb.* FROM 'test';
REVOKE ALTER ON zplatdb.* FROM 'test';
--回收表记录的增删改权限
REVOKE INSERT ON newythdb.* FROM 'test';
REVOKE UPDATE ON newythdb.* FROM 'test';
REVOKE DELETE ON newythdb.* FROM 'test';
查看权限列表:
SHOW GRANTS FOR 'test';
回收了建表、改表、删表后剩下的权限:
GRANT SELECT, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE ON *.* TO 'test'@'%'
如果全部权限,可以用all privileges
赋权只需要把revoke改为grant,from改为to即可:
grant all privileges on uacdb1.* to 'test';
刷新权限:
FLUSH PRIVILEGES