[pmg-devel] applied: [PATCH pmg-api v2] dbtools: grant permissions public schema for created databases

[Thomas Lamprecht]

Am 26/06/2023 um 16:10 schrieb Dominik Csapak:
> since postgres 15, the public schema is not world writeable anymore for
> security reasons. In our environment, where the db is not externaly
> reachable and no database users should exists except the ones we create,
> we can safely give the permissions again to be able to use
> the root/www-data user without modification of the remaining
> code/privileges for postgres.
> 
> Signed-off-by: Dominik Csapak <d.csapak at proxmox.com>
> ---
> changes from v1:
> * rename cmd to $grantcmd
> * actually use it and execute it with postgres_admin_cmd/psql
>  src/PMG/DBTools.pm | 10 ++++++++++
>  1 file changed, 10 insertions(+)
> 
>

applied, thanks!