Create a user named joe on localhost with a password of joe33
|
/*
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;
|
|
|
|
|
Related Scripts with Example Source Code in same category :
-
|
|