Getting started with occ and getting stuck with db permissions

ℹ️ Support
8

I created the nextcloud user with createuser --interactive and answered yes to all questions. So :

  • superuser
  • allowed to create databases
  • allowed to create more new roles

Here’s relevant part of the output of \l if it helps

postgres=# ─\l
                                   List of databases
   Name    |   Owner   | Encoding |   Collate   |    Ctype    |    Access privileges
-----------+-----------+----------+-------------+-------------+-------------------------
 nextcloud | nextcloud | UTF8     | en_US.UTF-8 | en_US.UTF-8 | nextcloud=CTc/nextcloud+
           |           |          |             |             | oc_theboss=c/nextcloud