MariaDB "EXECUTE AS" or User Impersonation
1
vote
3
answers
621
views
With MariaDB, is there a way to impersonate a user execution context when connected with a higher privileged account?
For instance, when connected with a "MasterUser" execute a SELECT using the more limited privileges of a "ClientUser".
The classic idea is to avoid the server application to perform thousands of connections to MariaDB -- if most requests could be handled through a "broker" user which would connect once and operate under the appropriate privilege level for each given transaction.
Thank you!
Asked by Jeff Reeves
(13 rep)
Nov 13, 2018, 09:06 PM
Last activity: Nov 23, 2021, 04:42 PM
Last activity: Nov 23, 2021, 04:42 PM