[MXS-2749] Allow filter to be applied by database role Created: 2019-10-31  Updated: 2020-11-16  Resolved: 2020-11-16

Status: Closed
Project: MariaDB MaxScale
Component/s: Filter
Affects Version/s: None
Fix Version/s: 6.0.0

Type: New Feature Priority: Major
Reporter: Assen Totin (Inactive) Assignee: Esa Korhonen
Resolution: Fixed Votes: 0
Labels: None

Sprint: MXS-SPRINT-116, MXS-SPRINT-117, MXS-SPRINT-118, MXS-SPRINT-119

 Description   

This is a feature request on behalf of a customer. The customer uses MaxScale filter to mask data, but woudl like to be able to specify not just applicable (or exempt) users, but also database roles.

To my untrained eye this seems possible, since roles are stored in MariaDB server and are applied using a SQL statement which goes through MaxScale - so MaxScale could be (or already is?) aware of the current role that the connected user has assumed (even if it is its default role) and adjust its behaviour accordingly.



 Comments   
Comment by Esa Korhonen [ 2020-11-16 ]

Only the general role tracking has been implemented. No filter yet reacts to role changes.

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