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

Status variables for number of global/db/table/column/role grants

Details

    Description

      Add status variables for number of rows in the mysql.user, db, tables_priv, columns_priv, procs_priv, role_mapping tables. This will show up in the feedback reports and we'll know typical number of grants that our users use, so that we could optimize for that.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          serg Sergei Golubchik created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Priority Major [ 3 ] Minor [ 4 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 29517 ] MariaDB v2 [ 44496 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.1 [ 16100 ]
          Fix Version/s 10.1.0 [ 12200 ]
          serg Sergei Golubchik made changes -
          Priority Minor [ 4 ] Major [ 3 ]
          cvicentiu Vicențiu Ciorbaru made changes -
          Assignee Vicentiu Ciorbaru [ cvicentiu ] Sergei Golubchik [ serg ]
          Status Open [ 1 ] In Review [ 10002 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Vicentiu Ciorbaru [ cvicentiu ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          cvicentiu Vicențiu Ciorbaru made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          cvicentiu Vicențiu Ciorbaru made changes -
          Assignee Vicentiu Ciorbaru [ cvicentiu ] Sergei Golubchik [ serg ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          serg Sergei Golubchik added a comment -

          ok to push

          serg Sergei Golubchik added a comment - ok to push
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Vicentiu Ciorbaru [ cvicentiu ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          cvicentiu Vicențiu Ciorbaru added a comment -

          Implemented with:

          1a329935374c799750ebe5cff56809789dd40539

          cvicentiu Vicențiu Ciorbaru added a comment - Implemented with: 1a329935374c799750ebe5cff56809789dd40539
          cvicentiu Vicențiu Ciorbaru made changes -
          Component/s Admin statements [ 11400 ]
          Fix Version/s 10.1.4 [ 18400 ]
          Fix Version/s 10.1 [ 16100 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 44496 ] MariaDB v3 [ 66311 ]
          elenst Elena Stepanova added a comment -

          serg, cvicentiu,

          Is it not a breach of security, although a minor one? A non-privileged user cannot read system tables, but can get a number of rows in them via status variables.

          elenst Elena Stepanova added a comment - serg , cvicentiu , Is it not a breach of security, although a minor one? A non-privileged user cannot read system tables, but can get a number of rows in them via status variables.
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 66311 ] MariaDB v4 [ 132211 ]

          People

            cvicentiu Vicențiu Ciorbaru
            serg Sergei Golubchik
            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.