Role Permissions and Object Access Management

[ghislaineguerin]

Problem

We currently don't have a way to see all the objects that a role has access to. We can only do this by navigating to each owned object for our current role and find the role in the list.

Proposed solution

Implement a separate UI for detailed role permissions, clearly displaying database, schema, and table permissions for roles.

Additional context

This was discussed as part of the issue for collaborator flow improvements:
#3969 (comment)

Outstanding Considerations:

Hierarchical vs. Flat Structure:

• Keep the object list flat rather than hierarchical to prevent user misunderstanding that schema-level permissions cascade to tables within.
• Ensure users clearly understand each object’s permissions are individually managed.

Permission Removal:

• How users can explicitly remove an object's access from a role ("No Access").

Co-existence of Role-level and Object-level Permissions:

• Can object-level owner permissions (individual schemas/tables) coexist alongside role-level settings?
• Role-level permissions offer efficient bulk management; object-level settings provide granular control.