Debian Codegraph @

mysql-test/suite/innodb/r/information_schema_grants.result

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