diff options
author | acurtis@pcgem.rdg.cyberkinetica.com <> | 2004-12-23 10:46:24 +0000 |
---|---|---|
committer | acurtis@pcgem.rdg.cyberkinetica.com <> | 2004-12-23 10:46:24 +0000 |
commit | b1e30904d5f10d2273819c25cb2dcc251a097bd9 (patch) | |
tree | 1f9ae909b765f73df023264dce5aa52d83e5cb8e /mysql-test/t/grant2.test | |
parent | 8fb20802dc0655cfd5895590d2b417f0c135b237 (diff) | |
download | mariadb-git-b1e30904d5f10d2273819c25cb2dcc251a097bd9.tar.gz |
WL#925 - Privileges for stored routines
Implement fine-grained control over access to stored procedures
Privileges are cached (same way as existing table/column privs)
Diffstat (limited to 'mysql-test/t/grant2.test')
-rw-r--r-- | mysql-test/t/grant2.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/grant2.test b/mysql-test/t/grant2.test index 69c42ce2252..ad3fc1c228e 100644 --- a/mysql-test/t/grant2.test +++ b/mysql-test/t/grant2.test @@ -64,10 +64,10 @@ connection mrbad; show grants for current_user(); use mysqltest; insert into t1 values (1, 'I can''t change it!'); ---error 1044 +--error 1142 update t1 set data='I can change it!' where id = 1; # This should not be allowed since it too require UPDATE privilege. ---error 1044 +--error 1142 insert into t1 values (1, 'XXX') on duplicate key update data= 'I can change it!'; select * from t1; @@ -199,7 +199,7 @@ create user mysqltest_2@localhost; grant usage on *.* to mysqltest_2@localhost with grant option; connect (user2,localhost,mysqltest_2,,); connection user2; ---error 1044 +--error 1142 select host,user,password from mysql.user where user like 'mysqltest_%' order by host,user,password; create user mysqltest_A@'%'; rename user mysqltest_A@'%' to mysqltest_B@'%'; |