[#MXS-1947] Composite roles are not supported

[MXS-1947] Composite roles are not supported Created: 2018-06-27 Updated: 2018-09-12 Resolved: 2018-09-12
Status:	Closed
Project:	MariaDB MaxScale
Component/s:	Authenticator
Affects Version/s:	2.2.9
Fix Version/s:	2.2.14

Type:

Bug

Priority:

Major

Reporter:

markus makela

Assignee:

markus makela

Resolution:

Fixed

Votes:

Labels:

None

Sprint:

MXS-SPRINT-65

Description

CREATE USER test;

CREATE ROLE a;

CREATE ROLE b;

CREATE DATABASE db;

GRANT ALL ON db.* TO a;

GRANT a TO b;

GRANT b TO test;

SET DEFAULT ROLE b FOR test;

Connecting with user test with db as default database will fail when it should succeed.

Generated at Thu Feb 08 04:10:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.