📖 Grant multiple users access to database tables via the AP UI

[michaeljcollinsuk]

User Story

As a user with access to manage a database table
I want to bulk grant access to multiple users
So that I dont have to grant access to each user individually

Value / Purpose

Will save the user time. This was a feature that was requested in a UR session

Useful Contacts

No response

User Types

No response

Hypothesis

If we... [do a thing]
Then... [this will happen]

Proposal

Currently when granting access to a table, you can only select a single user.

Instead users with grantable access to a table should be able to select multiple users to grant access to at the same time.

Additional Information

This work should come after work has been completed on replacing the user select component with the user search component tracked in this ticket.

Additionally, we may need to consider using a task queue such as Celery to handle the multiple boto3 requests, if there is no suitable bulk API request we can make.

Definition of Done

• Check Lake Formation API to see if there is a bulk API endpoint that we can use
• Consider if a task queue is necessary
• Update Lake Formation service based on findings from above
• Update form to allow multiple users to be selected
• Deployed to dev environment and tested

[github-actions]

This issue is being marked as stale because it has been open for 60 days with no activity. Remove stale label or comment to keep the issue open.

[github-actions]

This issue is being closed because it has been open for a further 7 days with no activity. If this is still a valid issue, please reopen it, Thank you!