[MDEV-24594] Proxy user to allow DBA to assume the identity of a user Created: 2021-01-14  Updated: 2021-01-26

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System
Fix Version/s: None

Type: Task Priority: Major
Reporter: Kyle Joiner (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Provide the ability to mimic a user:

In the Oracle World this requires a grant command and a special kind of connect command - the username would be a combination of my username and the username I would like to login using my credentials.
for example:
CREATE USER proxybenutzer IDENTIFIED BY proxypasswort;
(or use an existing database user)
Grant privilege:
ALTER USER scott GRANT CONNECT THROUGH proxybenutzer;
scott is the user account in which I would like to login
The connect- Statement changes for the proxy-user:
connect proxybenutzer[scott]/proxypasswort
Then I can connect as user "proxybenutzer" to the account "scott".


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