summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp-security.result
diff options
context:
space:
mode:
authormsvensson@neptunus.(none) <>2006-01-27 10:49:07 +0100
committermsvensson@neptunus.(none) <>2006-01-27 10:49:07 +0100
commit54af4e6d0caeff51b7d7541af18c06d1a99be974 (patch)
treeef0edf4b9c14460884d85ebaa6212e67e892a336 /mysql-test/r/sp-security.result
parenta98ede7edc48812113619ccf21389994e58b8332 (diff)
parent9304785c10c8cbf168b07e41c149f9f938c30428 (diff)
downloadmariadb-git-54af4e6d0caeff51b7d7541af18c06d1a99be974.tar.gz
Merge neptunus.(none):/home/msvensson/mysql/mysqltestrun_check_testcases/my50-mysqltestrun_check_testcases
into neptunus.(none):/home/msvensson/mysql/mysqltest_var/my50-mysqltest_var-integration
Diffstat (limited to 'mysql-test/r/sp-security.result')
-rw-r--r--mysql-test/r/sp-security.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/sp-security.result b/mysql-test/r/sp-security.result
index fbc6d64f9c9..b223c0cd487 100644
--- a/mysql-test/r/sp-security.result
+++ b/mysql-test/r/sp-security.result
@@ -134,7 +134,11 @@ drop database db2;
select type,db,name from mysql.proc;
type db name
delete from mysql.user where user='user1' or user='user2';
+delete from mysql.user where user='' and host='%';
delete from mysql.procs_priv where user='user1' or user='user2';
+delete from mysql.procs_priv where user='' and host='%';
+delete from mysql.db where user='user2';
+flush privileges;
grant usage on *.* to usera@localhost;
grant usage on *.* to userb@localhost;
grant usage on *.* to userc@localhost;
@@ -195,6 +199,9 @@ use test;
drop database sptest;
delete from mysql.user where user='usera' or user='userb' or user='userc';
delete from mysql.procs_priv where user='usera' or user='userb' or user='userc';
+delete from mysql.tables_priv where user='usera';
+flush privileges;
+drop table t1;
drop function if exists bug_9503;
create database mysqltest//
use mysqltest//