supabase/postgres-meta

Feature request: Add endpoint to CRUD column privileges

ruggi99 opened this issue · 0 comments

Chore

Describe the chore

This is a little step towards the goal of supporting custom roles and implement a better CLS (column level security).
I don't know if this is planned or not but I think the starting point is here in postgres-meta.

As a starting sql I found this snippet online:

SELECT grantee, table_name, column_name, privilege_type, is_grantable FROM information_schema.column_privileges WHERE table_schema = 'public' AND privilege_type != 'REFERENCES';

Additional context

Add any other context or screenshots that help clarify the task.