[
https://issues.apache.org/jira/browse/SENTRY-2437?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16667767#comment-16667767
]
Arjun Mishra edited comment on SENTRY-2437 at 10/29/18 9:05 PM:
----------------------------------------------------------------
Also with the current change revoke takes only 48.458 seconds for the above
example with REVOKE SELECT(col1, col2, .... col1800) FROM ROLE
was (Author: arjunmishra13):
Also with the current change revoke takes only 48.458 seconds.
> When granting privileges a single transaction per grant causes long delays
> --------------------------------------------------------------------------
>
> Key: SENTRY-2437
> URL: https://issues.apache.org/jira/browse/SENTRY-2437
> Project: Sentry
> Issue Type: Bug
> Components: Sentry
> Reporter: Arjun Mishra
> Assignee: Arjun Mishra
> Priority: Major
> Attachments: SENTRY-2437.01.patch
>
>
> Currently sentry creates a transaction for each TSentryPrivilege object it
> needs to grant. If the list of privileges is very large creating a single
> transaction for each significantly affects performance. This is particularly
> impactful for tables with large columns and if a user grants privileges to
> many of those columns
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)