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