Debian Codegraph @

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

raw
1 CREATE USER test@localhost;
2 SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='performance_schema' ORDER BY table_name;
3 TABLE_NAME
4 global_status
5 global_variables
6 persisted_variables
7 processlist
8 session_account_connect_attrs
9 session_status
10 session_variables
11 variables_info
12 GRANT SELECT ON performance_schema.cond_instances TO test@localhost;
13 GRANT SELECT ON performance_schema.setup_consumers TO test@localhost;
14 GRANT SELECT ON performance_schema.accounts TO test@localhost;
15 GRANT SELECT ON performance_schema.setup_objects TO test@localhost;
16 SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='performance_schema' ORDER BY table_name;
17 TABLE_NAME
18 accounts
19 cond_instances
20 global_status
21 global_variables
22 persisted_variables
23 processlist
24 session_account_connect_attrs
25 session_status
26 session_variables
27 setup_consumers
28 setup_objects
29 variables_info
30 SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION
31 FROM INFORMATION_SCHEMA.COLUMNS
32 WHERE TABLE_SCHEMA='performance_schema'
33 AND TABLE_NAME IN ('accounts', 'cond_instances', 'setup_consumers',
34 'setup_objects', 'processlist', 'global_status')
35 ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION, COLUMN_NAME;
36 TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION
37 performance_schema accounts USER 1
38 performance_schema accounts HOST 2
39 performance_schema accounts CURRENT_CONNECTIONS 3
40 performance_schema accounts TOTAL_CONNECTIONS 4
41 performance_schema accounts MAX_SESSION_CONTROLLED_MEMORY 5
42 performance_schema accounts MAX_SESSION_TOTAL_MEMORY 6
43 performance_schema cond_instances NAME 1
44 performance_schema cond_instances OBJECT_INSTANCE_BEGIN 2
45 performance_schema setup_consumers NAME 1
46 performance_schema setup_consumers ENABLED 2
47 performance_schema setup_objects OBJECT_TYPE 1
48 performance_schema setup_objects OBJECT_SCHEMA 2
49 performance_schema setup_objects OBJECT_NAME 3
50 performance_schema setup_objects ENABLED 4
51 performance_schema setup_objects TIMED 5
52 REVOKE ALL PRIVILEGES, GRANT OPTION FROM test@localhost;
53 DROP USER test@localhost;