Sample Header Ad - 728x90

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