Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.14, 10.1.17
-
None
-
10.1.18, 10.1.19, 10.1.22
Description
If a role is granted on the whole database (SELECT ON db.* TO role1;), and a user is granted this role (GRANT role1 TO user1;), then that databases is not listed by SHOW DATABASES;, but still can be used (set as default, SHOW TABLES IN ..., DESCRIBE ...)
Test case:
--error 0,ER_CANNOT_USER
|
drop user beep@'%';
|
|
|
--error 0,ER_CANNOT_USER
|
drop role r1;
|
|
|
drop database if exists db;
|
|
|
create role r1;
|
create user beep@'%';
|
|
|
create database db;
|
create table db.t1 (i int);
|
grant select on db.* to r1;
|
grant r1 to beep@'%';
|
|
|
--connect (con1,localhost,beep,,)
|
show databases;
|
set role r1;
|
show databases;
|
Expected result (hopefully):
drop user beep@'%';
|
drop role r1;
|
drop database if exists db;
|
Warnings:
|
Note 1008 Can't drop database 'db'; database doesn't exist
|
create role r1;
|
create user beep@'%';
|
create database db;
|
create table db.t1 (i int);
|
grant select on db.* to r1;
|
grant r1 to beep@'%';
|
show databases;
|
Database
|
information_schema
|
test
|
set role r1;
|
show databases;
|
Database
|
db
|
information_schema
|
test
|
Failing:
@@ -16,6 +16,5 @@
|
set role r1;
|
show databases;
|
Database
|
-db
|
information_schema
|
test
|
|
|
mysqltest: Result length mismatch
|
Attachments
Issue Links
- is blocked by
-
-
- Closed
-
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Priority | Minor [ 4 ] | Major [ 3 ] |
| Fix Version/s | 10.1 [ 16100 ] |
| Assignee | Vicentiu Ciorbaru [ cvicentiu ] |
| Sprint | 10.1.18 [ 98 ] |
| Sprint | 10.1.18 [ 98 ] | 10.1.18, 10.1.19 [ 98, 109 ] |
| Rank | Ranked higher |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Sprint | 10.1.18, 10.1.19 [ 98, 109 ] | 10.1.18, 10.1.19, 10.1.22 [ 98, 109, 143 ] |
| Rank | Ranked lower |
| Fix Version/s | 10.0 [ 16000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Fix Version/s | 10.0.32 [ 22504 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Link |
This issue relates to |
| Fix Version/s | 10.1.25 [ 22542 ] | |
| Fix Version/s | 10.2.7 [ 22543 ] |
| Link |
This issue is blocked by |
| Workflow | MariaDB v3 [ 76529 ] | MariaDB v4 [ 150685 ] |