table_privileges


Description

{“what”:“Rows each grant a set of boolean privileges on one table to one role.”,“why”:“Without it, access control decisions cannot be enforced; the system cannot know who may read or modify a table.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.768581743+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
table_id int4 10 null
metabase_table.id fk_table_privileges_table_id C

{“what”:“Integer ID of the table that the privileges apply to.”,“why”:“Identifies which table the privilege row governs; without it the grant is meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.788914046+00:00”}

role varchar 255 √ null

{“what”:“Role name that the privileges are granted to; null if the grant is not role-specific.”,“why”:“Determines which role gets the privileges; without it, the grant cannot be applied to the intended user or group.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.848792334+00:00”}

select bool 1 false

{“what”:“Boolean flag: true if the role can SELECT rows from the table.”,“why”:“Controls read access; without it, read permissions are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.870763913+00:00”}

update bool 1 false

{“what”:“Boolean flag: true if the role can UPDATE rows in the table.”,“why”:“Controls write access; without it, update permissions are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.910110776+00:00”}

insert bool 1 false

{“what”:“Boolean flag: true if the role can INSERT rows into the table.”,“why”:“Controls insert access; without it, insert permissions are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:17.088193110+00:00”}

delete bool 1 false

{“what”:“Boolean flag: true if the role can DELETE rows from the table.”,“why”:“Controls delete access; without it, delete permissions are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:17.151979954+00:00”}

Indexes

Constraint Name Type Sort Column(s)
idx_table_privileges_role Performance Asc role
idx_table_privileges_table_id Performance Asc table_id

Relationships