/*
mysql> GRANT ALL ON databaseName.sales TO joe@localhost IDENTIFIED BY "joe33";
Query OK, 0 rows affected (0.08 sec)
mysql> REVOKE DELETE, DROP, ALTER ON databaseName.sales FROM joe@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW GRANTS FOR joe@localhost;
+--------------------------------------+
| Grants for joe@localhost |
+--------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'joe'@'localhost' IDENTIFIED BY PASSWORD '*97F8
429BFFF8381BDD2BBA8733F8AC7561051548' |
| GRANT SELECT ON `databasename`.* TO 'joe'@'localhost' WITH GRANT OPTION
|
| GRANT SELECT, INSERT, UPDATE, CREATE, REFERENCES, INDEX ON `databasename`.`sal
es' TO 'joe'@'localhost' |
+--------------------------------------+
3 rows in set (0.01 sec)
*/
/*
Create a user named joe on localhost with a password of joe33, who has
ALL privileges on the sales table, and then revoke the DELETE, DROP, and
ALTER privileges.
*/
GRANT ALL ON databaseName.sales TO joe@localhost IDENTIFIED BY "joe33";
REVOKE DELETE, DROP, ALTER ON databaseName.sales FROM joe@localhost;
SHOW GRANTS FOR joe@localhost;