Re: [Maria-developers] When SP DEFINER is empty.

2016-06-25 Thread Sergei Golubchik
Hi, Alexey! I think, specify a non-empty DEFINER explicitly. Doesn't matter which one, it's mysql_install_db, so there are few definers that are guaranteed to exist (as they are created by mysql_install_db itself), use one of those, for example, root@localhost. Those procedures are SQL SECURITY

[Maria-developers] When SP DEFINER is empty.

2016-06-25 Thread Alexey Botchkov
Hi, Sergey, all. I'm in doubts about how this one should be fixed: https://jira.mariadb.org/browse/MDEV-10119 The story goes like this: - mysql_install_db script runs 'mysqld --skip-grant-tables' In this case the 'current_user()' seems to be empty. - so the CREATE PROCEDURE command i