Missing row permission for credits table

[Deanstirrat]

This may be an issue on my end but the supabase setup only allows the service_role to insert rows in the credit table but a new user needs access to create an initial row leap/train-model route. Either that or another supabase client object is needed with service_role permission like is done in the other leap routes.

Please correct me if I'm wrong.

[Marfuen]

@Deanstirrat Hey, if you don't mind reseting your database, we actually just generated a supabase migration file that will handle all of the policies for you.

If you want to reset it and let it do it for you then you can run this migration on your db
https://github.com/leap-ai/headshots-starter/blob/main/supabase/migrations/20231010160942_remote_schema.sql

You can follow their guide here: https://supabase.com/docs/guides/cli/managing-environments

[Marfuen]

@Deanstirrat If your issue is specifically with the service role, also, if you instantiated supabase with the service role key, then it should let you insert that first row.

[Marfuen]

More info / screenshots could help

[Deanstirrat]

@Marfuen got mine working. Thanks for your help