Permission change

[elsoa-invitech]

Trying to create test a table in public schema by a simple user:
CREATE TABLE "public"."test" ("test" varchar(255) NOT NULL, PRIMARY KEY ("test"));

We got "ERROR: permission denied for schema public" error, and this is why:

PostgreSQL 15 also revokes the CREATE permission from all users except a database owner from the public (or default) schema.
https://stackoverflow.com/a/75876944

    postgresql_pg_hba_custom:
      - { type: host, database: test2, user: test2, address: "10.192.0.0/20", method: "md5", comment: "test2 user engedelyezese" }

    postgresql_databases:
      - name: test2
        encoding: "UTF-8"
        lc_collate: en_US.UTF-8
        lc_ctype: en_US.UTF-8
        state: present
        
    postgresql_users:
      - name: test2
        pass: xxxx
        encrypted: yes
        state: present
    postgresql_user_privileges:
      - name: test2
        db: test2
        privs: ALL
        state: present