1select plugin_name,plugin_status as 'Must be ACTIVE' from information_schema.plugins where plugin_name like 'inno%' and plugin_status!='ACTIVE';
2plugin_name	Must be ACTIVE
3create user select_only@localhost;
4grant select on *.* to select_only@localhost;
5connect select_only,localhost,select_only;
6connection default;
7create sql security invoker view i_buffer_page as select * from information_schema.innodb_buffer_page;
8create sql security definer view d_buffer_page as select * from information_schema.innodb_buffer_page;
9create sql security invoker view i_buffer_page_lru as select * from information_schema.innodb_buffer_page_lru;
10create sql security definer view d_buffer_page_lru as select * from information_schema.innodb_buffer_page_lru;
11create sql security invoker view i_buffer_pool_stats as select * from information_schema.innodb_buffer_pool_stats;
12create sql security definer view d_buffer_pool_stats as select * from information_schema.innodb_buffer_pool_stats;
13create sql security invoker view i_cmp as select * from information_schema.innodb_cmp;
14create sql security definer view d_cmp as select * from information_schema.innodb_cmp;
15create sql security invoker view i_cmp_per_index as select * from information_schema.innodb_cmp_per_index;
16create sql security definer view d_cmp_per_index as select * from information_schema.innodb_cmp_per_index;
17create sql security invoker view i_cmp_per_index_reset as select * from information_schema.innodb_cmp_per_index_reset;
18create sql security definer view d_cmp_per_index_reset as select * from information_schema.innodb_cmp_per_index_reset;
19create sql security invoker view i_cmp_reset as select * from information_schema.innodb_cmp_reset;
20create sql security definer view d_cmp_reset as select * from information_schema.innodb_cmp_reset;
21create sql security invoker view i_cmpmem as select * from information_schema.innodb_cmpmem;
22create sql security definer view d_cmpmem as select * from information_schema.innodb_cmpmem;
23create sql security invoker view i_cmpmem_reset as select * from information_schema.innodb_cmpmem_reset;
24create sql security definer view d_cmpmem_reset as select * from information_schema.innodb_cmpmem_reset;
25create sql security invoker view i_ft_being_deleted as select * from information_schema.innodb_ft_being_deleted;
26create sql security definer view d_ft_being_deleted as select * from information_schema.innodb_ft_being_deleted;
27create sql security invoker view i_ft_config as select * from information_schema.innodb_ft_config;
28create sql security definer view d_ft_config as select * from information_schema.innodb_ft_config;
29create sql security invoker view i_ft_default_stopword as select * from information_schema.innodb_ft_default_stopword;
30create sql security definer view d_ft_default_stopword as select * from information_schema.innodb_ft_default_stopword;
31create sql security invoker view i_ft_deleted as select * from information_schema.innodb_ft_deleted;
32create sql security definer view d_ft_deleted as select * from information_schema.innodb_ft_deleted;
33create sql security invoker view i_ft_index_cache as select * from information_schema.innodb_ft_index_cache;
34create sql security definer view d_ft_index_cache as select * from information_schema.innodb_ft_index_cache;
35create sql security invoker view i_ft_index_table as select * from information_schema.innodb_ft_index_table;
36create sql security definer view d_ft_index_table as select * from information_schema.innodb_ft_index_table;
37create sql security invoker view i_lock_waits as select * from information_schema.innodb_lock_waits;
38create sql security definer view d_lock_waits as select * from information_schema.innodb_lock_waits;
39create sql security invoker view i_locks as select * from information_schema.innodb_locks;
40create sql security definer view d_locks as select * from information_schema.innodb_locks;
41create sql security invoker view i_metrics as select * from information_schema.innodb_metrics;
42create sql security definer view d_metrics as select * from information_schema.innodb_metrics;
43create sql security invoker view i_mutexes as select * from information_schema.innodb_mutexes;
44create sql security definer view d_mutexes as select * from information_schema.innodb_mutexes;
45create sql security invoker view i_sys_columns as select * from information_schema.innodb_sys_columns;
46create sql security definer view d_sys_columns as select * from information_schema.innodb_sys_columns;
47create sql security invoker view i_sys_datafiles as select * from information_schema.innodb_sys_datafiles;
48create sql security definer view d_sys_datafiles as select * from information_schema.innodb_sys_datafiles;
49create sql security invoker view i_sys_fields as select * from information_schema.innodb_sys_fields;
50create sql security definer view d_sys_fields as select * from information_schema.innodb_sys_fields;
51create sql security invoker view i_sys_foreign as select * from information_schema.innodb_sys_foreign;
52create sql security definer view d_sys_foreign as select * from information_schema.innodb_sys_foreign;
53create sql security invoker view i_sys_foreign_cols as select * from information_schema.innodb_sys_foreign_cols;
54create sql security definer view d_sys_foreign_cols as select * from information_schema.innodb_sys_foreign_cols;
55create sql security invoker view i_sys_indexes as select * from information_schema.innodb_sys_indexes;
56create sql security definer view d_sys_indexes as select * from information_schema.innodb_sys_indexes;
57create sql security invoker view i_sys_semaphore_waits as select * from information_schema.innodb_sys_semaphore_waits;
58create sql security definer view d_sys_semaphore_waits as select * from information_schema.innodb_sys_semaphore_waits;
59create sql security invoker view i_sys_tables as select * from information_schema.innodb_sys_tables;
60create sql security definer view d_sys_tables as select * from information_schema.innodb_sys_tables;
61create sql security invoker view i_sys_tablespaces as select * from information_schema.innodb_sys_tablespaces;
62create sql security definer view d_sys_tablespaces as select * from information_schema.innodb_sys_tablespaces;
63create sql security invoker view i_sys_tablestats as select * from information_schema.innodb_sys_tablestats;
64create sql security definer view d_sys_tablestats as select * from information_schema.innodb_sys_tablestats;
65create sql security invoker view i_sys_virtual as select * from information_schema.innodb_sys_virtual;
66create sql security definer view d_sys_virtual as select * from information_schema.innodb_sys_virtual;
67create sql security invoker view i_tablespaces_encryption as select * from information_schema.innodb_tablespaces_encryption;
68create sql security definer view d_tablespaces_encryption as select * from information_schema.innodb_tablespaces_encryption;
69create sql security invoker view i_trx as select * from information_schema.innodb_trx;
70create sql security definer view d_trx as select * from information_schema.innodb_trx;
71connection select_only;
72select count(*) > -1 from information_schema.innodb_buffer_page;
73ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
74select count(*) > -1 from i_buffer_page;
75ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
76select count(*) > -1 from d_buffer_page;
77count(*) > -1
781
79select count(*) > -1 from information_schema.innodb_buffer_page_lru;
80ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
81select count(*) > -1 from i_buffer_page_lru;
82ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
83select count(*) > -1 from d_buffer_page_lru;
84count(*) > -1
851
86select count(*) > -1 from information_schema.innodb_buffer_pool_stats;
87ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
88select count(*) > -1 from i_buffer_pool_stats;
89ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
90select count(*) > -1 from d_buffer_pool_stats;
91count(*) > -1
921
93select count(*) > -1 from information_schema.innodb_cmp;
94ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
95select count(*) > -1 from i_cmp;
96ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
97select count(*) > -1 from d_cmp;
98count(*) > -1
991
100select count(*) > -1 from information_schema.innodb_cmp_per_index;
101ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
102select count(*) > -1 from i_cmp_per_index;
103ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
104select count(*) > -1 from d_cmp_per_index;
105count(*) > -1
1061
107select count(*) > -1 from information_schema.innodb_cmp_per_index_reset;
108ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
109select count(*) > -1 from i_cmp_per_index_reset;
110ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
111select count(*) > -1 from d_cmp_per_index_reset;
112count(*) > -1
1131
114select count(*) > -1 from information_schema.innodb_cmp_reset;
115ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
116select count(*) > -1 from i_cmp_reset;
117ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
118select count(*) > -1 from d_cmp_reset;
119count(*) > -1
1201
121select count(*) > -1 from information_schema.innodb_cmpmem;
122ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
123select count(*) > -1 from i_cmpmem;
124ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
125select count(*) > -1 from d_cmpmem;
126count(*) > -1
1271
128select count(*) > -1 from information_schema.innodb_cmpmem_reset;
129ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
130select count(*) > -1 from i_cmpmem_reset;
131ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
132select count(*) > -1 from d_cmpmem_reset;
133count(*) > -1
1341
135select count(*) > -1 from information_schema.innodb_ft_being_deleted;
136ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
137select count(*) > -1 from i_ft_being_deleted;
138ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
139select count(*) > -1 from d_ft_being_deleted;
140count(*) > -1
1411
142select count(*) > -1 from information_schema.innodb_ft_config;
143ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
144select count(*) > -1 from i_ft_config;
145ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
146select count(*) > -1 from d_ft_config;
147count(*) > -1
1481
149select count(*) > -1 from information_schema.innodb_ft_default_stopword;
150count(*) > -1
1511
152select count(*) > -1 from information_schema.innodb_ft_deleted;
153ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
154select count(*) > -1 from i_ft_deleted;
155ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
156select count(*) > -1 from d_ft_deleted;
157count(*) > -1
1581
159select count(*) > -1 from information_schema.innodb_ft_index_cache;
160ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
161select count(*) > -1 from i_ft_index_cache;
162ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
163select count(*) > -1 from d_ft_index_cache;
164count(*) > -1
1651
166select count(*) > -1 from information_schema.innodb_ft_index_table;
167ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
168select count(*) > -1 from i_ft_index_table;
169ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
170select count(*) > -1 from d_ft_index_table;
171count(*) > -1
1721
173select count(*) > -1 from information_schema.innodb_lock_waits;
174ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
175select count(*) > -1 from i_lock_waits;
176ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
177select count(*) > -1 from d_lock_waits;
178count(*) > -1
1791
180select count(*) > -1 from information_schema.innodb_locks;
181ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
182select count(*) > -1 from i_locks;
183ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
184select count(*) > -1 from d_locks;
185count(*) > -1
1861
187select count(*) > -1 from information_schema.innodb_metrics;
188ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
189select count(*) > -1 from i_metrics;
190ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
191select count(*) > -1 from d_metrics;
192count(*) > -1
1931
194select count(*) > -1 from information_schema.innodb_mutexes;
195ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
196select count(*) > -1 from i_mutexes;
197ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
198select count(*) > -1 from d_mutexes;
199count(*) > -1
2001
201select count(*) > -1 from information_schema.innodb_sys_columns;
202ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
203select count(*) > -1 from i_sys_columns;
204ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
205select count(*) > -1 from d_sys_columns;
206count(*) > -1
2071
208select count(*) > -1 from information_schema.innodb_sys_datafiles;
209ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
210select count(*) > -1 from i_sys_datafiles;
211ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
212select count(*) > -1 from d_sys_datafiles;
213count(*) > -1
2141
215select count(*) > -1 from information_schema.innodb_sys_fields;
216ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
217select count(*) > -1 from i_sys_fields;
218ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
219select count(*) > -1 from d_sys_fields;
220count(*) > -1
2211
222select count(*) > -1 from information_schema.innodb_sys_foreign;
223ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
224select count(*) > -1 from i_sys_foreign;
225ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
226select count(*) > -1 from d_sys_foreign;
227count(*) > -1
2281
229select count(*) > -1 from information_schema.innodb_sys_foreign_cols;
230ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
231select count(*) > -1 from i_sys_foreign_cols;
232ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
233select count(*) > -1 from d_sys_foreign_cols;
234count(*) > -1
2351
236select count(*) > -1 from information_schema.innodb_sys_indexes;
237ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
238select count(*) > -1 from i_sys_indexes;
239ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
240select count(*) > -1 from d_sys_indexes;
241count(*) > -1
2421
243select count(*) > -1 from information_schema.innodb_sys_semaphore_waits;
244ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
245select count(*) > -1 from i_sys_semaphore_waits;
246ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
247select count(*) > -1 from d_sys_semaphore_waits;
248count(*) > -1
2491
250select count(*) > -1 from information_schema.innodb_sys_tables;
251ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
252select count(*) > -1 from i_sys_tables;
253ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
254select count(*) > -1 from d_sys_tables;
255count(*) > -1
2561
257select count(*) > -1 from information_schema.innodb_sys_tablespaces;
258ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
259select count(*) > -1 from i_sys_tablespaces;
260ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
261select count(*) > -1 from d_sys_tablespaces;
262count(*) > -1
2631
264select count(*) > -1 from information_schema.innodb_sys_tablestats;
265ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
266select count(*) > -1 from i_sys_tablestats;
267ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
268select count(*) > -1 from d_sys_tablestats;
269count(*) > -1
2701
271select count(*) > -1 from information_schema.innodb_sys_virtual;
272ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
273select count(*) > -1 from i_sys_virtual;
274ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
275select count(*) > -1 from d_sys_virtual;
276count(*) > -1
2771
278select count(*) > -1 from information_schema.innodb_tablespaces_encryption;
279ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
280select count(*) > -1 from i_tablespaces_encryption;
281ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
282select count(*) > -1 from d_tablespaces_encryption;
283count(*) > -1
2841
285select count(*) > -1 from information_schema.innodb_trx;
286ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
287select count(*) > -1 from i_trx;
288ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
289select count(*) > -1 from d_trx;
290count(*) > -1
2911
292connection default;
293drop database test;
294create database test;
295drop user select_only@localhost;
296