Debian Codegraph @

mysql-test/suite/perfschema/r/keyring_keys_privileges.result

raw
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;