Debian Codegraph @

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

raw
1 ** Setup **
2
3 SET @default_check_proxy_users = @@check_proxy_users;
4 '#----- 1.2.4 superuser set variable -------------------------#'
5 SET Global check_proxy_users=OFF;
6 '#----- 1.2.4 others user set variable -----------------------#'
7 ** Creating new user with out super privilege**
8 CREATE USER sameea;
9 ** Connecting connn using username 'sameea' **
10 SET GLOBAL check_proxy_users=ON;
11 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
12 SET @@global.check_proxy_users=ON;
13 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
14 ** Connection default **
15 ** Disconnecting connn **
16 DROP USER sameea;
17 SET global check_proxy_users = @default_check_proxy_users;