[Database] Make available a list of User Permissions per Group and Project
Problem to solve
(From original issue)
Its cumbersome to culminate a list of permissions for each user, across all groups and projects on their instance. Currently, there is no summary available to see this information and as a work around customers are using a script to generate the data view they need.
Please refer to the Technical implementation section for the complete details on how we plan to implement this feature.
This particular issue pertains the database changes required for this feature.
Proposal
When a user requests a CSV export of User Permissions, the background job generates the report and uploads the file for the user to be able to download.
Suggested schema:
Column | Type |
---|---|
user |
references to users table |
status |
integer |
file_store |
integer |
file |
string |
Further details
Add constraint on user
to be admin only, as admin users can only request for User permission exports.