You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sentry.apache.org by "Na Li (Jira)" <ji...@apache.org> on 2019/12/11 20:41:00 UTC

[jira] [Created] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES command based on configuration

Na Li created SENTRY-2540:
-----------------------------

             Summary: Only use SELECT action for filter SHOW DATABASES command based on configuration
                 Key: SENTRY-2540
                 URL: https://issues.apache.org/jira/browse/SENTRY-2540
             Project: Sentry
          Issue Type: Improvement
            Reporter: Na Li


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 based on configuration.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)