[SENTRY-2437] When granting privileges a single transaction per grant causes long delays

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.2.0
• Component/s: Sentry
• Assignee: Arjun Mishra
• Reporter: Arjun Mishra
• Created: 29/Oct/18 16:42
• Updated: 02/Jan/20 17:08
• Resolved: 30/Oct/18 20:46

Description

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

Issue Links

• links to: Review board link