| 1 |
CREATE USER happygilmore@localhost identified by 'happy'; |
| 2 |
GRANT SELECT ON *.* TO happygilmore@localhost; |
| 3 |
SHOW GRANTS; |
| 4 |
Grants for happygilmore@localhost |
| 5 |
GRANT SELECT ON *.* TO `happygilmore`@`localhost` |
| 6 |
SELECT * FROM performance_schema.keyring_keys; |
| 7 |
KEY_ID KEY_OWNER BACKEND_KEY_ID |
| 8 |
REVOKE SELECT ON *.* FROM happygilmore@localhost; |
| 9 |
SHOW GRANTS; |
| 10 |
Grants for happygilmore@localhost |
| 11 |
GRANT USAGE ON *.* TO `happygilmore`@`localhost` |
| 12 |
SELECT * FROM performance_schema.keyring_keys; |
| 13 |
ERROR 42000: SELECT command denied to user 'happygilmore'@'localhost' for table 'keyring_keys' |
| 14 |
GRANT SELECT ON *.* TO happygilmore@localhost; |
| 15 |
SHOW GRANTS; |
| 16 |
Grants for happygilmore@localhost |
| 17 |
GRANT SELECT ON *.* TO `happygilmore`@`localhost` |
| 18 |
SELECT * FROM performance_schema.keyring_keys; |
| 19 |
KEY_ID KEY_OWNER BACKEND_KEY_ID |
| 20 |
DROP USER happygilmore@localhost; |