Debian Codegraph @

mysql-test/suite/sys_vars/t/check_proxy_users_func.test

raw
1 ############ mysql-test\t\check_proxy_users_func.test###########################
2 # #
3 #Variable Name: check_proxy_users #
4 #Scope: SESSION #
5 #Access Type: Dynamic #
6 #Data Type: BOOLEAN #
7 #Default Value: OFF #
8 #Values: ON, OFF #
9 # #
10 # #
11 #Creation Date: 2015-01-20 #
12 #Author: Todd Farmer #
13 # #
14 #Description: Test Cases of Dynamic System Variable "check_proxy_users" #
15 # that checks behavior of this variable in the following ways #
16 # * Functionality based on different values #
17 # #
18 #Reference: http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#
19 # option_mysqld_check_proxy_users #
20 # #
21 ################################################################################
22
23 --echo ** Setup **
24 --echo
25 #
26 # Setup
27 #
28
29 SET @default_check_proxy_users = @@check_proxy_users;
30
31 --echo '#----- 1.2.4 superuser set variable -------------------------#'
32 ###################################
33 # Setting Read only value ON #
34 ###################################
35
36 SET Global check_proxy_users=OFF;
37
38 --echo '#----- 1.2.4 others user set variable -----------------------#'
39 ##########################################
40 # Creating user without Super privilege #
41 ##########################################
42
43 --echo ** Creating new user with out super privilege**
44 CREATE USER sameea;
45 --echo ** Connecting connn using username 'sameea' **
46 CONNECT (connn,localhost,sameea,,);
47
48 --Error ER_SPECIFIC_ACCESS_DENIED_ERROR
49 SET GLOBAL check_proxy_users=ON;
50 --Error ER_SPECIFIC_ACCESS_DENIED_ERROR
51 SET @@global.check_proxy_users=ON;
52 #
53 # Cleanup
54 #
55 --echo ** Connection default **
56 connection default;
57
58 --echo ** Disconnecting connn **
59 DISCONNECT connn;
60
61 DROP USER sameea;
62
63 SET global check_proxy_users = @default_check_proxy_users;
64
65 --disable_info