Debian Codegraph @

mysql-test/suite/sys_vars/r/sha256_password_proxy_users_func.result

raw
1 ** Setup **
2
3 SET @default_sha256_password_proxy_users = @@global.sha256_password_proxy_users;
4 SET @default_check_proxy_users = @@global.check_proxy_users;
5 '#----- 3.2.4 With super privileges --------------------------#'
6 SET Global sha256_password_proxy_users=OFF;
7 '#----- 3.2.4 Without super privileges ------------------------#'
8 ** Creating new user with out super privilege**
9 CREATE USER sameea;
10 ** Connecting connn using username 'sameea' **
11 SET GLOBAL sha256_password_proxy_users=ON;
12 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
13 SET @@global.sha256_password_proxy_users=ON;
14 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
15 ** Connection default **
16 ** Closing connection **
17 '#----- 3.2.2.2 check OFF and sha256 OFF -------------------#'
18 SET Global sha256_password_proxy_users=OFF;
19 SELECT @@global.check_proxy_users;
20 @@global.check_proxy_users
21 0
22 ** Creating new base user **
23 CREATE USER ''@localhost;
24 '#----- 4.4) Test to ensure users not defined with any PROXY privileges log in normally.-#';
25 CREATE USER proxy_base@localhost;
26 GRANT ALTER ON *.* TO proxy_base@localhost;
27 ** Creating new proxy user **
28 CREATE USER proxy_sha256@localhost IDENTIFIED WITH sha256_password;
29 GRANT CREATE ON *.* TO proxy_base@localhost;
30 GRANT PROXY ON proxy_base@localhost TO proxy_sha256@localhost;
31 ** Creating new proxy user with missing base user **
32 CREATE USER proxy_none@localhost IDENTIFIED WITH sha256_password;
33 GRANT PROXY ON proxy_blah@localhost TO proxy_none@localhost;
34 '#----- 4.3)Test to ensure proxy privileges are not chained. ----------------------------#';
35 CREATE USER proxy_base_multi@localhost;
36 GRANT SELECT ON *.* TO proxy_base_multi@localhost;
37 ** Creating new proxy user **
38 CREATE USER proxy_sha256_1@localhost IDENTIFIED WITH sha256_password;
39 GRANT DELETE ON *.* TO proxy_sha256_1@localhost;
40 CREATE USER proxy_sha256_2@localhost IDENTIFIED WITH sha256_password;
41 GRANT INSERT,DELETE ON *.* TO proxy_sha256_2@localhost;
42 CREATE USER proxy_sha256_3@localhost IDENTIFIED WITH sha256_password;
43 GRANT SELECT,DELETE ON *.* TO proxy_sha256_3@localhost;
44 GRANT PROXY ON proxy_base_multi@localhost TO proxy_sha256_1@localhost;
45 GRANT PROXY ON proxy_base_multi@localhost TO proxy_sha256_2@localhost;
46 GRANT PROXY ON proxy_base_multi@localhost TO proxy_sha256_3@localhost;
47 ** Creating new proxy user **
48 CREATE USER proxy_sha256_4@localhost IDENTIFIED WITH sha256_password;
49 CREATE USER proxy_sha256_41@localhost IDENTIFIED WITH sha256_password;
50 GRANT PROXY ON proxy_base@localhost TO proxy_sha256_4@localhost;
51 GRANT PROXY ON proxy_base_multi@localhost TO proxy_sha256_4@localhost;
52 GRANT INSERT ON *.* TO proxy_sha256_4@localhost;
53 GRANT PROXY ON proxy_sha256_4@localhost TO proxy_sha256_41@localhost;
54 GRANT UPDATE ON *.* TO proxy_sha256_41@localhost;
55 '#----- 4.2.check_proxy_users=OFF: sha256_password_proxy_users=OFF -----#';
56 ** Connecting as proxy_sha256 with proxy mapping disabled **
57 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
58 CURRENT_USER() USER() @@session.proxy_user
59 proxy_sha256@localhost proxy_sha256@localhost NULL
60 SHOW GRANTS;
61 Grants for proxy_sha256@localhost
62 GRANT USAGE ON *.* TO `proxy_sha256`@`localhost`
63 GRANT PROXY ON `proxy_base`@`localhost` TO `proxy_sha256`@`localhost`
64 ** Connection default **
65 ALTER USER 'proxy_sha256'@'localhost' IDENTIFIED BY 'testpw';
66 ** Connecting as proxy_sha256, password with proxy mapping disabled **
67 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
68 CURRENT_USER() USER() @@session.proxy_user
69 proxy_sha256@localhost proxy_sha256@localhost NULL
70 SHOW GRANTS;
71 Grants for proxy_sha256@localhost
72 GRANT USAGE ON *.* TO `proxy_sha256`@`localhost`
73 GRANT PROXY ON `proxy_base`@`localhost` TO `proxy_sha256`@`localhost`
74 ** Connection default **
75 ALTER USER 'proxy_sha256'@'localhost' IDENTIFIED BY '';
76 ** Connecting as proxy_none with proxy mapping disabled **
77 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
78 CURRENT_USER() USER() @@session.proxy_user
79 proxy_none@localhost proxy_none@localhost NULL
80 SHOW GRANTS;
81 Grants for proxy_none@localhost
82 GRANT USAGE ON *.* TO `proxy_none`@`localhost`
83 GRANT PROXY ON `proxy_blah`@`localhost` TO `proxy_none`@`localhost`
84 ** Connecting as proxy_sha256_1 with proxy mapping disabled **
85 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
86 CURRENT_USER() USER() @@session.proxy_user
87 proxy_sha256_1@localhost proxy_sha256_1@localhost NULL
88 SHOW GRANTS;
89 Grants for proxy_sha256_1@localhost
90 GRANT DELETE ON *.* TO `proxy_sha256_1`@`localhost`
91 GRANT PROXY ON `proxy_base_multi`@`localhost` TO `proxy_sha256_1`@`localhost`
92 ** Connecting as proxy_sha256_2 with proxy mapping disabled **
93 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
94 CURRENT_USER() USER() @@session.proxy_user
95 proxy_sha256_2@localhost proxy_sha256_2@localhost NULL
96 SHOW GRANTS;
97 Grants for proxy_sha256_2@localhost
98 GRANT INSERT, DELETE ON *.* TO `proxy_sha256_2`@`localhost`
99 GRANT PROXY ON `proxy_base_multi`@`localhost` TO `proxy_sha256_2`@`localhost`
100 ** Connecting as proxy_sha256_4 with proxy mapping disabled **
101 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
102 CURRENT_USER() USER() @@session.proxy_user
103 proxy_sha256_4@localhost proxy_sha256_4@localhost NULL
104 SHOW GRANTS;
105 Grants for proxy_sha256_4@localhost
106 GRANT INSERT ON *.* TO `proxy_sha256_4`@`localhost`
107 GRANT PROXY ON `proxy_base`@`localhost` TO `proxy_sha256_4`@`localhost`
108 GRANT PROXY ON `proxy_base_multi`@`localhost` TO `proxy_sha256_4`@`localhost`
109 ** Connection default **
110 ** Disconnecting connections **
111 '#----- 3.2.2.1 check OFF and sha256 ON ----------------------#'
112 '#----- 4.2.check_proxy_users=OFF: sha256_password_proxy_users=ON ------#';
113 SET Global sha256_password_proxy_users=ON;
114 ** Connecting as proxy_sha256 with proxy mapping disabled (sha256 mapping on) **
115 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
116 CURRENT_USER() USER() @@session.proxy_user
117 proxy_sha256@localhost proxy_sha256@localhost NULL
118 SHOW GRANTS;
119 Grants for proxy_sha256@localhost
120 GRANT USAGE ON *.* TO `proxy_sha256`@`localhost`
121 GRANT PROXY ON `proxy_base`@`localhost` TO `proxy_sha256`@`localhost`
122 ** Connection default **
123 ALTER USER 'proxy_sha256'@'localhost' IDENTIFIED BY 'testpw';
124 ** Connecting as proxy_sha256, password with proxy mapping disabled (sha256 mapping on) **
125 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
126 CURRENT_USER() USER() @@session.proxy_user
127 proxy_sha256@localhost proxy_sha256@localhost NULL
128 SHOW GRANTS;
129 Grants for proxy_sha256@localhost
130 GRANT USAGE ON *.* TO `proxy_sha256`@`localhost`
131 GRANT PROXY ON `proxy_base`@`localhost` TO `proxy_sha256`@`localhost`
132 ** Connection default **
133 ALTER USER 'proxy_sha256'@'localhost' IDENTIFIED BY '';
134 ** Connecting as proxy_none with proxy mapping disabled (sha256 mapping on) **
135 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
136 CURRENT_USER() USER() @@session.proxy_user
137 proxy_none@localhost proxy_none@localhost NULL
138 SHOW GRANTS;
139 Grants for proxy_none@localhost
140 GRANT USAGE ON *.* TO `proxy_none`@`localhost`
141 GRANT PROXY ON `proxy_blah`@`localhost` TO `proxy_none`@`localhost`
142 ** Connecting as proxy_sha256_1 with proxy mapping disabled (sha256 mapping on)**
143 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
144 CURRENT_USER() USER() @@session.proxy_user
145 proxy_sha256_1@localhost proxy_sha256_1@localhost NULL
146 SHOW GRANTS;
147 Grants for proxy_sha256_1@localhost
148 GRANT DELETE ON *.* TO `proxy_sha256_1`@`localhost`
149 GRANT PROXY ON `proxy_base_multi`@`localhost` TO `proxy_sha256_1`@`localhost`
150 ** Connecting as proxy_sha256_2 with proxy mapping disabled (sha256 mapping on) **
151 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
152 CURRENT_USER() USER() @@session.proxy_user
153 proxy_sha256_2@localhost proxy_sha256_2@localhost NULL
154 SHOW GRANTS;
155 Grants for proxy_sha256_2@localhost
156 GRANT INSERT, DELETE ON *.* TO `proxy_sha256_2`@`localhost`
157 GRANT PROXY ON `proxy_base_multi`@`localhost` TO `proxy_sha256_2`@`localhost`
158 ** Connecting as proxy_sha256_4 with proxy mapping disabled (sha256 mapping on) **
159 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
160 CURRENT_USER() USER() @@session.proxy_user
161 proxy_sha256_4@localhost proxy_sha256_4@localhost NULL
162 SHOW GRANTS;
163 Grants for proxy_sha256_4@localhost
164 GRANT INSERT ON *.* TO `proxy_sha256_4`@`localhost`
165 GRANT PROXY ON `proxy_base`@`localhost` TO `proxy_sha256_4`@`localhost`
166 GRANT PROXY ON `proxy_base_multi`@`localhost` TO `proxy_sha256_4`@`localhost`
167 ** Connecting as chained proxy_sha256_41 with proxy mapping disabled (sha256 mapping on) **
168 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
169 CURRENT_USER() USER() @@session.proxy_user
170 proxy_sha256_41@localhost proxy_sha256_41@localhost NULL
171 SHOW GRANTS;
172 Grants for proxy_sha256_41@localhost
173 GRANT UPDATE ON *.* TO `proxy_sha256_41`@`localhost`
174 GRANT PROXY ON `proxy_sha256_4`@`localhost` TO `proxy_sha256_41`@`localhost`
175 ** Connection default **
176 GRANT PROXY ON ''@localhost TO proxy_sha256_1@localhost;
177 ** Connecting as Anonymus with proxy mapping disabled (sha256 mapping on) **
178 SELECT @@session.proxy_user IS NOT NULL;
179 @@session.proxy_user IS NOT NULL
180 0
181 ** Connection default **
182 REVOKE PROXY ON ''@localhost FROM proxy_sha256_1@localhost;
183 ** Connection default **
184 ** Disconnecting connections **
185 '#----- 3.2.2.1 check and sha256 ON --------------------------#'
186 '#----- 4.2.check_proxy_users=ON: sha256_password_proxy_users=ON ------#';
187 SET Global check_proxy_users=ON;
188 ** Connecting as proxy_sha256 with proxy mapping enabled **
189 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
190 CURRENT_USER() USER() @@session.proxy_user
191 proxy_base@localhost proxy_sha256@localhost 'proxy_sha256'@'localhost'
192 SHOW GRANTS;
193 Grants for proxy_base@localhost
194 GRANT CREATE, ALTER ON *.* TO `proxy_base`@`localhost`
195 ** Connection default **
196 ALTER USER 'proxy_sha256'@'localhost' IDENTIFIED BY 'testpw';
197 ** Connecting as proxy_sha256, password with proxy mapping enabled **
198 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
199 CURRENT_USER() USER() @@session.proxy_user
200 proxy_base@localhost proxy_sha256@localhost 'proxy_sha256'@'localhost'
201 SHOW GRANTS;
202 Grants for proxy_base@localhost
203 GRANT CREATE, ALTER ON *.* TO `proxy_base`@`localhost`
204 ** Connection default **
205 ALTER USER 'proxy_sha256'@'localhost' IDENTIFIED BY '';
206 ** Connecting as proxy_sha256 with proxy mapping enabled **
207 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
208 CURRENT_USER() USER() @@session.proxy_user
209 proxy_none@localhost proxy_none@localhost NULL
210 SHOW GRANTS;
211 Grants for proxy_none@localhost
212 GRANT USAGE ON *.* TO `proxy_none`@`localhost`
213 GRANT PROXY ON `proxy_blah`@`localhost` TO `proxy_none`@`localhost`
214 ** Connecting as proxy_sha256_1 with proxy mapping enabled **
215 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
216 CURRENT_USER() USER() @@session.proxy_user
217 proxy_base_multi@localhost proxy_sha256_1@localhost 'proxy_sha256_1'@'localhost'
218 SHOW GRANTS;
219 Grants for proxy_base_multi@localhost
220 GRANT SELECT ON *.* TO `proxy_base_multi`@`localhost`
221 ** Connecting as proxy_sha256_2 with proxy mapping enabled **
222 SELECT CURRENT_USER(), USER(), @@session.proxy_user;
223 CURRENT_USER() USER() @@session.proxy_user
224 proxy_base_multi@localhost proxy_sha256_2@localhost 'proxy_sha256_2'@'localhost'
225 SHOW GRANTS;
226 Grants for proxy_base_multi@localhost
227 GRANT SELECT ON *.* TO `proxy_base_multi`@`localhost`
228 ** Connecting as proxy_sha256_4 with proxy mapping enabled **
229 SELECT CURRENT_USER() IN ('proxy_base@localhost','proxy_base_multi@localhost');
230 CURRENT_USER() IN ('proxy_base@localhost','proxy_base_multi@localhost')
231 1
232 SELECT USER(), @@session.proxy_user;
233 USER() @@session.proxy_user
234 proxy_sha256_4@localhost 'proxy_sha256_4'@'localhost'
235 SHOW GRANTS;
236 Grants for proxy_base@localhost
237 GRANT CREATE, ALTER ON *.* TO `proxy_base`@`localhost`
238 ** Connecting as chained proxy_sha256_41 with proxy mapping enabled **
239 SELECT CURRENT_USER() IN ('proxy_base@localhost','proxy_base_multi@localhost');
240 CURRENT_USER() IN ('proxy_base@localhost','proxy_base_multi@localhost')
241 0
242 SELECT CURRENT_USER() IN ('proxy_sha256_4@localhost');
243 CURRENT_USER() IN ('proxy_sha256_4@localhost')
244 1
245 SELECT USER(), @@session.proxy_user;
246 USER() @@session.proxy_user
247 proxy_sha256_41@localhost 'proxy_sha256_41'@'localhost'
248 SHOW GRANTS;
249 Grants for proxy_sha256_4@localhost
250 GRANT INSERT ON *.* TO `proxy_sha256_4`@`localhost`
251 GRANT PROXY ON `proxy_base`@`localhost` TO `proxy_sha256_4`@`localhost`
252 GRANT PROXY ON `proxy_base_multi`@`localhost` TO `proxy_sha256_4`@`localhost`
253 ** Connection default **
254 GRANT PROXY ON ''@localhost TO proxy_sha256_1@localhost;
255 ** Connecting as Anonymus with proxy mapping enabled **
256 SELECT @@session.proxy_user IS NOT NULL;
257 @@session.proxy_user IS NOT NULL
258 0
259 ** Connection default **
260 REVOKE PROXY ON ''@localhost FROM proxy_sha256_1@localhost;
261 ** Disconnecting connections **
262 ** Connection default **
263 DROP USER ''@localhost;
264 DROP USER proxy_base@localhost;
265 DROP USER proxy_base_multi@localhost;
266 DROP USER proxy_sha256@localhost;
267 DROP USER proxy_none@localhost;
268 DROP USER proxy_sha256_1@localhost;
269 DROP USER proxy_sha256_2@localhost;
270 DROP USER proxy_sha256_3@localhost;
271 DROP USER proxy_sha256_4@localhost;
272 DROP USER proxy_sha256_41@localhost;
273 DROP USER sameea;
274 SET @@global.sha256_password_proxy_users = @default_sha256_password_proxy_users;
275 SET @@global.check_proxy_users = @default_check_proxy_users;