diff options
author | serg@serg.mylan <> | 2004-02-15 17:59:52 +0100 |
---|---|---|
committer | serg@serg.mylan <> | 2004-02-15 17:59:52 +0100 |
commit | e9c46aaf8015d3bacd8461dae8a2dd02fe1eb1f7 (patch) | |
tree | bad5934f75efc1de2854982f41f4d6712ef7896e /mysql-test/t/grant.test | |
parent | 01c2ca5b8adbb6ad86defe286c294ff43ba864cb (diff) | |
download | mariadb-git-e9c46aaf8015d3bacd8461dae8a2dd02fe1eb1f7.tar.gz |
REVOKE ALL PRIVILEGES, GRANT FROM user_list
is changed to a more consistent
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_list.
Bug #2642
Diffstat (limited to 'mysql-test/t/grant.test')
-rw-r--r-- | mysql-test/t/grant.test | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test index 78221fa4e40..7255f872bb7 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -100,18 +100,18 @@ select 1; -- To test that the previous command didn't cause problems create table t1 (a int); grant ALL PRIVILEGES on *.* to drop_user2@localhost with GRANT OPTION; show grants for drop_user2@localhost; -revoke all privileges, grant from drop_user2@localhost; +revoke all privileges, grant option from drop_user2@localhost; drop user drop_user2@localhost; grant ALL PRIVILEGES on *.* to drop_user@localhost with GRANT OPTION; grant ALL PRIVILEGES on test.* to drop_user@localhost with GRANT OPTION; grant select(a) on test.t1 to drop_user@localhost; show grants for drop_user@localhost; -revoke all privileges, grant from drop_user@localhost; +revoke all privileges, grant option from drop_user@localhost; show grants for drop_user@localhost; drop user drop_user@localhost; --error 1268 -revoke all privileges, grant from drop_user@localhost; +revoke all privileges, grant option from drop_user@localhost; grant select(a) on test.t1 to drop_user1@localhost; grant select on test.t1 to drop_user2@localhost; @@ -120,7 +120,7 @@ grant select on *.* to drop_user4@localhost; --error 1267 drop user drop_user1@localhost, drop_user2@localhost, drop_user3@localhost, drop_user4@localhost; -revoke all privileges, grant from drop_user1@localhost, drop_user2@localhost, +revoke all privileges, grant option from drop_user1@localhost, drop_user2@localhost, drop_user3@localhost, drop_user4@localhost; drop user drop_user1@localhost, drop_user2@localhost, drop_user3@localhost, drop_user4@localhost; |