burggraf/supabase-mailer

Unable to change keys

Speaka opened this issue · 0 comments

I'm trying to change my Mailjet secret key in the supabase web sql console.
UPDATE private.keys set value='NEW_KEY_HERE' where key ='MAILJET_SECRET_KEY';
But i'm getting the following error:
Failed to run sql query: permission denied for schema private
It seems the permisson where revoked. listing the tables posgres user is not the owner of the table:
schemaname | tablename | tableowner
private | keys | supabase_admin

GRANT UPDATE ON TABLE private.keys TO postgres; also fails due to missing permission.
How can i achive to update the keys or drop the schema/table and rerun the setup_keys script?
Thanks in advance!

Edit:
I fetched the current user when using supabase web:
in my project i am working as "postgres".
In a new empty project as "supabase_admin".
This might be the reasen but i don't know how to fix this.

seems to be a supabase issue