Uploaded image for project: 'Sentry'
  1. Sentry
  2. SENTRY-2540

Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.2.0, 2.3.0
    • Component/s: None
    • Labels:
      None

      Description

      When there are thousands of databases, SHOW DATABASES may take a really long time because SENTRY checks if user has any of the following privileges on that database for filtering out the database

      DBModelAction.SELECT, DBModelAction.INSERT, DBModelAction.ALTER,
      DBModelAction.CREATE, DBModelAction.DROP, DBModelAction.INDEX,
      DBModelAction.LOCK

      To speedup the authorization checking for this case, Sentry can check only the select privilege for SHOW DATABASES and SHOW TABLES based on configuration.

        Attachments

        1. SENTRY-2540.003.patch
          14 kB
          Na Li
        2. SENTRY-2540.003.patch
          14 kB
          Na Li
        3. SENTRY-2540.003.patch
          14 kB
          Na Li
        4. SENTRY-2540.003.patch
          14 kB
          Na Li
        5. SENTRY-2540.003.patch
          14 kB
          Na Li
        6. SENTRY-2540.002.patch
          13 kB
          Na Li
        7. SENTRY-2540.002.patch
          13 kB
          Na Li
        8. SENTRY-2540.001.patch
          6 kB
          Na Li

          Issue Links

            Activity

              People

              • Assignee:
                linaataustin Na Li
                Reporter:
                linaataustin Na Li
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: