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

            Unassigned Unassigned
            kjoiner Kyle Joiner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.