15 lines
414 B
Text
15 lines
414 B
Text
--echo #
|
|
--echo # Bug #30628160: DYNAMIC PRIVILEGES CAN BE GRANTED AT PROCEDURE/FUNCTION LEVEL
|
|
--echo #
|
|
|
|
CREATE SCHEMA B30628160;
|
|
CREATE PROCEDURE B30628160.p1() SELECT 1;
|
|
CREATE USER B30628160@localhost;
|
|
--echo # The test: must fail.
|
|
--error ER_ILLEGAL_PRIVILEGE_LEVEL
|
|
GRANT xyzzy ON PROCEDURE B30628160.p1 TO B30628160@localhost;
|
|
|
|
DROP USER B30628160@localhost;
|
|
DROP SCHEMA B30628160;
|
|
|
|
--echo # End of 8.0 tests
|