21 lines
826 B
Plaintext
21 lines
826 B
Plaintext
CREATE USER happygilmore@localhost identified by 'happy';
|
|
GRANT SELECT ON *.* TO happygilmore@localhost;
|
|
SHOW GRANTS;
|
|
Grants for happygilmore@localhost
|
|
GRANT SELECT ON *.* TO `happygilmore`@`localhost`
|
|
SELECT * FROM performance_schema.keyring_keys;
|
|
KEY_ID KEY_OWNER BACKEND_KEY_ID
|
|
REVOKE SELECT ON *.* FROM happygilmore@localhost;
|
|
SHOW GRANTS;
|
|
Grants for happygilmore@localhost
|
|
GRANT USAGE ON *.* TO `happygilmore`@`localhost`
|
|
SELECT * FROM performance_schema.keyring_keys;
|
|
ERROR 42000: SELECT command denied to user 'happygilmore'@'localhost' for table 'keyring_keys'
|
|
GRANT SELECT ON *.* TO happygilmore@localhost;
|
|
SHOW GRANTS;
|
|
Grants for happygilmore@localhost
|
|
GRANT SELECT ON *.* TO `happygilmore`@`localhost`
|
|
SELECT * FROM performance_schema.keyring_keys;
|
|
KEY_ID KEY_OWNER BACKEND_KEY_ID
|
|
DROP USER happygilmore@localhost;
|