567
567
DROP USER 'Tester';
568
568
DROP DATABASE B48872;
569
569
End of 5.0 tests.
571
# Bug#11882603 SELECT_ACL ON ANY COLUMN IN MYSQL.PROC ALLOWS TO SEE
572
# DEFINITION OF ANY ROUTINE.
574
DROP DATABASE IF EXISTS db1;
576
CREATE PROCEDURE db1.p1() SELECT 1;
577
CREATE USER user2@localhost IDENTIFIED BY '';
578
GRANT SELECT(db) ON mysql.proc TO user2@localhost;
579
# Connection con2 as user2
580
# The statement below before disclosed info from body_utf8 column.
581
SHOW CREATE PROCEDURE db1.p1;
582
ERROR 42000: PROCEDURE p1 does not exist
583
# Check that SHOW works with SELECT grant on whole table
585
GRANT SELECT ON mysql.proc TO user2@localhost;
588
SHOW CREATE PROCEDURE db1.p1;
589
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
590
p1 CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
591
SELECT 1 latin1 latin1_swedish_ci latin1_swedish_ci
593
DROP USER user2@localhost;