Unable to access view decrypted_secrets from cron job ERROR: pgsodium_crypto_aead_det_decrypt_by_id: invalid ciphertext

[sagi-reeeally]

Bug report

• [X] I confirm this is a bug with Supabase, not with my own application.
• [X] I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

Trying to run a cron_job that access the view decrypted_secrets.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

Create a cron_job that runs every once in a while (with user postgres) With a function that tries to access the view decrypted_secrets

Expected behavior

The cron_job is successful and accessed the view decrypted_secrets

System information

-- Running on the Supabase Cloud

[bartoszpijet]

Take a look at #27