[FR] Support multiple owners/admins and introduce RBAC or group-based management

[harrison-xrb]

Feature Description

Currently, Sourcebot only supports a single owner with full management permissions, which limits the ability to delegate or share administrative responsibilities. It would be highly beneficial to support multiple owners or admins who have access to the same management features as the current owner.

Additionally, implementing groups or a role-based access control (RBAC) system would allow more flexible and secure management of permissions. This would allow organizations to:

• Assign multiple owners, admins, or groups with varying management roles
• Define which users/groups can access sensitive settings, billing, or upgrade features
• More easily delegate responsibilities, especially in larger teams

Benefits:

• Increased operational resilience (no single point of failure if the owner is unavailable)
• Better organizational security and flexibility
• Easier management of users, permissions, and sensitive actions

User Story

• As an organization, I want to assign multiple owners or admins who can manage the workspace, users, billing, and advanced features.
• As an admin, I want to delegate fine-grained permissions to specific users or groups, without granting full owner access.

[msukkari]

Thanks for the suggestion @harrison-xrb ! Other than accepting/removing members, what specific permissions would you like to be able to offer to multiple members in the deployment?

[harrison-xrb]

I think this would be a nice feature to support now and features can be added as the platform grows.

Right now we would like access to settings/members and settings/connections. It would also allow admins to see the update notification if #815 was implemented.