Security user@max-host vs user@%

Description

I have a situation where I want ALL adhoc users to connect through maxscale for auditing purposes.

I would like to be able to give a user "GRANT PRIVS ON DB_NAME to USER@MAXSCALE_HOST;" to be able to connect from anywhere (faux user@%) but only through MAXSCALE_HOST. If I give user@% privs, and connect through maxscale host, from anywhere, the user shows up as USER@MAXSCALE_HOST not from where USER is connected from. Is there any way that this can be changed?

Environment

None

Assignee

Unassigned

Reporter

Chris

Labels

None

Priority

Critical
Configure