Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each impersonation rule.”,“why”:“Provides a stable key for referencing and modifying specific rules.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:58.751035660+00:00”} |
||||
| db_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the database connection that can be impersonated.”,“why”:“Specifies the target connection for the impersonation rule.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:58.767234353+00:00”} |
|||||
| group_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the group that is allowed to impersonate.”,“why”:“Determines which group has the impersonation permission.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:58.793917616+00:00”} |
|||||
| attribute | text | 2147483647 | √ | null |
|
|
{“what”:“Optional text qualifier such as a role name or condition.”,“why”:“Refines the impersonation rule; without it, the rule applies to all contexts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:58.808760658+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| connection_impersonations_pkey | Primary key | Asc | id |
| conn_impersonation_unique_group_id_db_id | Must be unique | Asc/Asc | group_id + db_id |
| idx_conn_impersonations_db_id | Performance | Asc | db_id |
| idx_conn_impersonations_group_id | Performance | Asc | group_id |