| 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; |