cashless2ecash

commit 46e70bf41a9dc4c93fdf1a600cf78c80cf19a534
parent 7112c8641d9aec090f6dc4f5cd1e1fcbb1062455
Author: Joel-Haeberli <haebu@rubigen.ch>
Date:   Sat, 18 May 2024 11:00:21 +0200

fix: privileges

Diffstat:
M
c2ec/db/access.sql
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/c2ec/db/access.sql b/c2ec/db/access.sql
@@ -13,7 +13,7 @@ CREATE USER c2ec_operator WITH ENCRYPTED PASSWORD OPERATOR_PASSWORD;
 CREATE USER c2ec_api WITH ENCRYPTED PASSWORD API_PASSWORD;
 
 GRANT USAGE ON SCHEMA _v TO c2ec_admin;
-GRANT ALL PRIVILEGES _v.patches TO c2ec_admin;
+GRANT ALL PRIVILEGES ON _v.patches TO c2ec_admin;
 GRANT EXECUTE ON FUNCTION _v.register_patch TO c2ec_admin;
 
 GRANT ALL PRIVILEGES ON DATABASE DB_NAME TO c2ec_admin;