"new row violates row-level security policy" error for every insert call

[TheOnlyTails]

I have this insert call which runs every time a user sends a message in a discord channel:

client.postgrest["scores"].insert(
    User(it.author.name, discordId = it.author.idLong),
    upsert = true,
).decodeAs<User>()

but every time I send to trigger it, I get this error message:

io.github.jan.supabase.exceptions.RestException: Unknown error: {"code":"42501","details":null,"hint":null,"message":"new row violates row-level security policy for table \"scores\""} (HTTP status 401) 

[jan-tennert]

It might be that you only have access to inserting in the table but not selecting, so try to set the returning parameter to minimal (which won't return the changed row when calling decodeAs) or change the rls policy. But it seems like you want to receive the updated data so you probably have to look in your policies

[TheOnlyTails]

I get the data so I can increment the score later on, but I don't have any RLS policies, so IDK why this is happening

[jan-tennert]

So RLS is generally disabled for "scores"?

[TheOnlyTails]

It's enabled, there just aren't any policies.

[jan-tennert]

If you have RLS enabled, and have no policies, supabase will not allow any requests to the table as there are no policies. You'd have to disable RLS if you don't have policies. Also there's no point in enabling it if you don't need it

[TheOnlyTails]

Alright, that works!