[ https://issues.apache.org/jira/browse/SENTRY-2540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Na Li updated SENTRY-2540: -------------------------- Summary: Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration (was: Only use SELECT action for filter SHOW DATABASES command based on configuration) > Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command > based on configuration > ----------------------------------------------------------------------------------------------- > > Key: SENTRY-2540 > URL: https://issues.apache.org/jira/browse/SENTRY-2540 > Project: Sentry > Issue Type: Improvement > Reporter: Na Li > Assignee: Na Li > Priority: Major > > 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)