Enable/Disabled Column-level privileges from the config.toml
There is, apparently, no documentation on how to enable/disable the Column-level privileges from the
config.toml
Even this piece of documentation https://supabase.com/docs/guides/database/postgres/column-level-security don't even explain how to disabled it from the GUI.4 Replies
You don't enable/disable them as settings. They are a Postgres feature you setup with SQL altering each table. This is a non-trivial exercise. There is an experimental UI that does the SQL setup for you. I believe a current limitation of that is also that migrations do not handle the column privileges, so you have to hand code it any way.
Well, there is a button to “activate this feature” on the GUI to make this feature (at least visible).
Migrations does handle column privileges if written manually, but “migra” will try to override them on every single migration afterwards, trying to revert custom grants
That just turns on the UI. It does not enable the feature. It is all part of Postgres
Alright then. The wording was confusing I guess. Thank you