storage.objects table is owned by supabase_storage_admin and can't transfer ownership topostgres

[gipsea]

Hi there.
I cant connect to the storage with ownership error. after few check I realized storage.object is owned by supabase_storage_admin. I tried to transfer the ownership to postgres with
ALTER TABLE storage.objects OWNER TO postgres;
and again I received the ownership error so I can't access the storage. nay hints? I'm new to supabase so I'm in the blind

cheers

[GaryAustin1]

What are you trying to do. You should not need to be the owner of storage schema tables. They are protected.
You can add RLS and read/insert/update them thru SQL or the storage API calls.

[gipsea]

Thanks for your reply.
this is the SQL I use to enable RLS:
ALTER TABLE storage.objects ENABLE ROW LEVEL SECURITY;
this is the SQL result:
ERROR: 42501: must be owner of table objects.

Giving the fact this is the first time I'm working with supabase, I might have sone something wrong creating the bucket. I'm more then happy to delete this bucket and run the correct SQL if you could share it. Doing with via UI didn't work and I want to avoid keep doing the same error. SQL can't go wrong :)

thanks forrì your support

[GaryAustin1]

RLS should already be enabled for storage.objects.

You should just add your policies, not enable it which Supabase is not allowing because they don't want you to turn it off.