[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ https://issues.apache.org/jira/browse/SENTRY-2540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kalyan Kalvagadda updated SENTRY-2540: -- Fix Version/s: 2.3.0 2.2.0 Resolution: Fixed Status: Resolved (was: Patch Available) > 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 > Fix For: 2.2.0, 2.3.0 > > 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ 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 > > > 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ 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 > > > 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ 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 > > > 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ 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.002.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 > > > 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ 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.002.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 > > > 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ https://issues.apache.org/jira/browse/SENTRY-2540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Na Li updated SENTRY-2540: -- Status: Patch Available (was: Open) > 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 > > > 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ 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.001.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 > > > 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ 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)
[jira] [Updated] (SENTRY-2540) Only use SELECT action for filter SHOW DATABASES and SHOW TABLES command based on configuration
[ https://issues.apache.org/jira/browse/SENTRY-2540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Na Li updated SENTRY-2540: -- 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. was: 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. > 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 and SHOW TABLES based on > configuration. -- This message was sent by Atlassian Jira (v8.3.4#803005)