# Problem running EHRBase 2.2.0 with Azure Database for PostgreSQL servers

**Category:** [Implementation](https://discourse.openehr.org/c/implem/39)
**Created:** 2024-06-06 11:12 UTC
**Views:** 143
**Replies:** 2
**URL:** https://discourse.openehr.org/t/problem-running-ehrbase-2-2-0-with-azure-database-for-postgresql-servers/5330

---

## Post #1 by @Dileep_V_S

Hi,
I am trying to run EHRBase 2.2.0 using an Azure Database for PostgreSQL servers. When I run the createdb.sql, i get the following error
```
ehrbase=> ALTER FUNCTION jsonb_path_query(jsonb,jsonpath,jsonb,boolean) ROWS 1;
ERROR:  must be owner of function jsonb_path_query
```
I contacted Azure support and they mentioned that since this is a Super user owned function, and this is a PAAS, they cannot allow ALTER on it . 

This is a showstopper and the same prolem could happen with other hosted Cloud providers also. Can the EHRBase team suggest any work around? @birger.haarbrandt

---

## Post #2 by @stefanspiska

@Dileep_V_S 

please see https://github.com/ehrbase/ehrbase/issues/1317

---

## Post #3 by @Dileep_V_S

Thank you

regards

---


**Canonical:** https://discourse.openehr.org/t/problem-running-ehrbase-2-2-0-with-azure-database-for-postgresql-servers/5330
**Original content:** https://discourse.openehr.org/t/problem-running-ehrbase-2-2-0-with-azure-database-for-postgresql-servers/5330