Team Management Visibility Fix

Bug Fix

Team Management Page Now Shows All Members

Fixed an issue where the Team Management page only displayed the current user instead of all team members.

Root Cause: The tenant_members table's RLS (Row-Level Security) policy was too restrictive - it only allowed users to see their own membership record.

Fix: Updated the policy to allow users to see all members of tenants they belong to, which matches the existing permission system where team.view is available to all roles.

Changes

• Replaced tenant_members_own_memberships policy with tenant_members_tenant_isolation
• Added UPDATE policy for role changes (owner/admin only)
• Added INSERT policy for adding members (owner/admin only)