Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24594

Proxy user to allow DBA to assume the identity of a user

    XMLWordPrintable

    Details

      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".

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            kjoiner Kyle Joiner
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration