New to the cloud SQL service, so create a postgres 12.4 database and created a user with admin rights. But cannot use the 'create schema...' command - get permission denied.
beepaid_db=> CREATE SCHEMA myschema2;
ERROR: permission denied for database beepaid_db
beepaid_db=>
Could someone else please verify this command does not work on their postgres database.
Or have I setup so,mething wrong here. The reason why schemas are important to me is I use django-tenants - and this in turn makes use of this postgres feature.
Have a ticketr open with OVH support - after one week still awaiting a formal response on this - hence reaching out to community to see if there is a workaround/solution.
Many thanks in advance - dave
Bases de données - Postgres 'create schema abc'; fails with permission denied
Related questions
- Lien database non établi
16553
06.12.2016 11:04
- Intégration de MongoDB
16143
12.10.2016 09:01
- Autoriser toutes les IP
16058
11.08.2018 19:16
- "Connection timed out" - Connection MySQL privée via PHP
15214
13.02.2018 00:37
- Comment passer de MySQL 5.6 à MySQL 8.0 ?
14588
12.06.2019 15:49
- Help, Base de donnée pleine, supprimer product ID phpmyadmin
13463
12.06.2019 14:05
- [1034] Create index by sort failed
13283
06.03.2020 09:31
- Exporter la base de données avec un script PHP
12420
05.10.2018 11:27
- Connexion à base de données en utilisant ODBC
12196
04.09.2018 11:57
- Les connexions simultanées
12041
24.10.2019 13:23
Same problem here. Did you found a solution?
same problem as before
Hello,
We could not give you this privilege because we manage privileges on each schemas. So if you need to create a new schema, you can use another database or simply prefix your tables.
I hope this will help you to fix your needs.