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

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

        Details

        • Type: Task
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Fix Version/s: 10.1.4
        • Component/s: Admin statements
        • Labels:
          None

          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.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                ok to push

                Show
                serg Sergei Golubchik added a comment - ok to push
                Hide
                Permalink
                cvicentiu Vicentiu Ciorbaru added a comment -

                Implemented with:

                1a329935374c799750ebe5cff56809789dd40539

                Show
                cvicentiu Vicentiu Ciorbaru added a comment - Implemented with: 1a329935374c799750ebe5cff56809789dd40539
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Sergei Golubchik, Vicentiu Ciorbaru,

                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.

                Show
                elenst Elena Stepanova added a comment - Sergei Golubchik , Vicentiu Ciorbaru , 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.

                  People

                  • Assignee:
                    cvicentiu Vicentiu Ciorbaru
                    Reporter:
                    serg Sergei Golubchik
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    5 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 day, 3 hours, 30 minutes
                      1d 3h 30m