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

Separate SUPER and READ ONLY ADMIN privileges

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

            Transition Time In Source Status Execution Times
            Michael Widenius made transition -
            Open In Progress
            		1m 5s 1
            Michael Widenius made transition -
            In Progress In Testing
            		2m 14s 1
            Elena Stepanova made transition -
            In Testing Stalled
            		6d 6h 27m 1
            Michael Widenius made transition -
            In Progress Needs Feedback
            		6s 1
            Michael Widenius made transition -
            Needs Feedback Closed
            		6s 1
            Michael Widenius made transition -
            Closed Stalled
            		8s 1
            Michael Widenius made transition -
            Stalled In Progress
            		1d 10h 13m 2
            Sergei Golubchik made transition -
            In Progress Stalled
            		1h 13m 1
            Sergei Golubchik made transition -
            Stalled Closed
            		8h 37m 1

            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.