I try to let the temporal connect to Azure PostgreSQL for data persistence.
Get Unable to SQL schema—permission denied for schema public.
I am using PostgreSQL 16.4 and trying to run GRANT ALL ON SCHEMA public TO temporal for the temporal user, but I still get the error.
Thanks!