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

Separate SUPER and READ ONLY ADMIN privileges

    XMLWordPrintable

Details

    Description

      Remove READ ONLY ADMIN from the SUPER privilege

      The benefit of this is that one can remove the READ ONLY ADMIN privilege
      from all users and this way ensure that no one can do any changes on
      any non-temporary tables.

      This is good option to use on slaves when one wants to ensure that the
      slave is kept identical to the master.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29632 SUPER users created before 10.11 should retain READ_ONLY ADMIN privilege upon upgrade

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29641 Help topics say SUPER is required to bypass read_only

          • Major - Major loss of function.
          • Open
          is part of

          Task - A task that needs to be done. MDEV-29547 prepare 10.11.0 preview releases

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-9458 FR: Super read-only mode

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-29668 SUPER should not allow actions that have fine-grained dedicated privileges

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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