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

MariaDB Galera not replicating GRANTS of roles to users

    XMLWordPrintable

Details

    Description

      From a user: We use Galera, MariaDB and MariaDB roles, and Galera refuses to sync the GRANTS of roles to users. We have a separate user for each account where we need to apply the security role, and with a multi-master setup (Galera), the roles won’t get synced to each node, leaving the security model broken (so some users will have read/write permissions only on one of the nodes). The role is already replicated, only the GRANT for USER is not replicated, so hope that latest MariaDB (10.1.5) with Galera sets the role. The trick-shot here being that in 10.1.1 you added the “DEFAULT ROLE” feature which means that one doesn’t need to GRANT roleX to userY, you and one do it automatically at user setup (hoping that the user setup with a default role is replicated). But 10.1.5 is still a BETA now, so I can’t use it in production yet. We could potentially have workaround for now and wait until the problem gets fixed.

      Attachments

        Activity

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            ratzpo Rasmus Johansson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.