[
https://issues.apache.org/jira/browse/SENTRY-2540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Na Li updated SENTRY-2540:
--------------------------
Attachment: SENTRY-2540.003.patch
> 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
> Attachments: SENTRY-2540.001.patch, SENTRY-2540.002.patch,
> SENTRY-2540.002.patch, SENTRY-2540.003.patch, SENTRY-2540.003.patch,
> SENTRY-2540.003.patch, SENTRY-2540.003.patch, SENTRY-2540.003.patch
>
>
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
