Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.20
-
Ubuntu Linux 16.04.1 LTS x64, KVM, Centos 7, VMWare
Description
Sample:
GRANT SELECT, INSERT, UPDATE, DELETE ON test_1.* to user1@'192.168.122.10%';
user1 can SELECT, INSERT, UPDATE and SELECT on tables in database test_1.
After adding
grant execute on `test_%`.* to user1@'192.168.122.10%';
user1 gets permission denied when trying to access a table in test_1.
Customer environment has several databases all with a suffix per client company and DBA wanted to grant EXECUTE permission for all databases in one statement.
Workaround in this case:
Explicitly GRANT EXECUTE for each database.
Attachments
Issue Links
- relates to
-
MDEV-11929 During delete: InnoDB: Assertion failure in thread 139757855127296 in file buf0buf.cc line 4803
-
- Closed
-
I can't reproduce it right away, at least on the current 10.1.
What does SHOW GRANTS say when you connect as user1?
Please also attach your cnf file(s), maybe there is something in there.