external_guest_access_grants
Represents active access granted to external users after accepting an invite.
Purpose
Track and enforce permissions for external users.
Columns
| Column | Type | Description |
|---|---|---|
| id | uuid | Primary key |
| text | External user email | |
| resource_type | text | Resource type |
| resource_id | uuid | Resource ID |
| permissions | text[] | read/comment/etc |
| granted_at | timestamptz | Grant time |
| expires_at | timestamptz | Expiry |
Usage
- Checked on every external request
- Works with token/session system