diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/secure_timestamp_super.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/secure_timestamp_super.result | 30 |
1 files changed, 29 insertions, 1 deletions
diff --git a/mysql-test/suite/sys_vars/r/secure_timestamp_super.result b/mysql-test/suite/sys_vars/r/secure_timestamp_super.result index 6fbb5e5fbf0..e005fdabf8a 100644 --- a/mysql-test/suite/sys_vars/r/secure_timestamp_super.result +++ b/mysql-test/suite/sys_vars/r/secure_timestamp_super.result @@ -4,20 +4,48 @@ connection slave; select @@secure_timestamp; @@secure_timestamp SUPER +### ALL PRIVILEGES +set timestamp=1234567890.101112; +select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'ALL PRIVILEGES'; +ALL PRIVILEGES +EDITABLE +set timestamp=default; +### SUPER +create user foo@127.0.0.1; +grant super on *.* TO `foo`@`127.0.0.1`; +connect con2,127.0.0.1,foo,,test,$SLAVE_MYPORT; set timestamp=1234567890.101112; select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'SUPER'; SUPER EDITABLE +disconnect con2; +connection slave; +drop user foo@127.0.0.1; +set timestamp=default; +### BINLOG REPLAY +create user foo@127.0.0.1; +grant binlog replay on *.* TO `foo`@`127.0.0.1`; +connect con2,127.0.0.1,foo,,test,$SLAVE_MYPORT; +set timestamp=1234567890.101112; +select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'BINLOG REPLAY'; +BINLOG REPLAY +EDITABLE +disconnect con2; +connection slave; +drop user foo@127.0.0.1; +set timestamp=default; +### non-privileged user create user foo@127.0.0.1; connect con2,127.0.0.1,foo,,test,$SLAVE_MYPORT; set timestamp=1234567890.101112; -ERROR 42000: Access denied; you need (at least one of) the SUPER privilege(s) for this operation +ERROR 42000: Access denied; you need (at least one of) the SUPER, BINLOG REPLAY privilege(s) for this operation select if(now(6) > 20100101, 'READONLY', 'EDITABLE') as 'non-privileged'; non-privileged READONLY disconnect con2; connection slave; drop user foo@127.0.0.1; +set timestamp=default; connection master; set time_zone='+00:00'; set timestamp=1234567890.101112; |