Can’t grant column-level SELECT privileges in Supabase Postgres

Hi
I’m trying to give the anon role access to only a few columns in my bookings table.
Here’s what I tried:

GRANT SELECT (employee_id, start_ts, end_ts, status) ON bookings TO anon;
But when I check with:
SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name = 'bookings';

GRANT SELECT (employee_id, start_ts, end_ts, status) ON bookings TO anon;
But when I check with:
SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name = 'bookings';

it doesn’t show up at all.
If I do

GRANT SELECT ON bookings TO anon;

GRANT SELECT ON bookings TO anon;

then it works — but that gives access to all columns.
So… is column-level GRANT SELECT not supported in Supabase’s Postgres setup? Or am I missing something?

Supabase•4mo ago•

34 replies

Doriim

Can’t grant column-level SELECT privileges in Supabase Postgres

Hi
I’m trying to give the anon role access to only a few columns in my bookings table.
Here’s what I tried:

GRANT SELECT (employee_id, start_ts, end_ts, status) ON bookings TO anon;
But when I check with:
SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name = 'bookings';

GRANT SELECT (employee_id, start_ts, end_ts, status) ON bookings TO anon;
But when I check with:
SELECT grantee, privilege_type
FROM information_schema.role_table_grants
WHERE table_name = 'bookings';

it doesn’t show up at all.
If I do

GRANT SELECT ON bookings TO anon;

GRANT SELECT ON bookings TO anon;

then it works — but that gives access to all columns.
So… is column-level GRANT SELECT not supported in Supabase’s Postgres setup? Or am I missing something?

Can’t grant column-level SELECT privileges in Supabase Postgres

Similar Threads

Can’t grant column-level SELECT privileges in Supabase Postgres

Similar Threads

Similar Threads

Similar Threads