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

Add variable to block queries to risky information_schema tables

    XMLWordPrintable

Details

    Description

      Customer has had issues when querying tables such as information_schema.innodb_buffer_page and a few others that have the potential to cause production downtime in high concurrency environments.

      A variable such as super_only_risky_tables to only allow super or root users to query these tables could help negate this risk.

      Having this variable enabled makes the tables inaccessible for non super users.

      Another option is a specific grant that does the same thing such as GRANT VERBOSE SCHEMA etc

      Attachments

        Activity

          People

            serg Sergei Golubchik
            manjot Manjot Singh (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.