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
Postgres 'create schema abc'; fails with permission denied
Sujets apparentés
- Lien database non établi
6965
06.12.2016 11:04
- "Connection timed out" - Connection MySQL privée via PHP
6907
13.02.2018 00:37
- Autoriser toutes les IP
5049
11.08.2018 19:16
- Help, Base de donnée pleine, supprimer product ID phpmyadmin
4936
12.06.2019 14:05
- Intégration de MongoDB
4916
12.10.2016 09:01
- Comment passer de MySQL 5.6 à MySQL 8.0 ?
4482
12.06.2019 15:49
- Connexion à base de données en utilisant ODBC
4398
04.09.2018 11:57
- Les connexions simultanées
4215
24.10.2019 13:23
- Exporter la base de données avec un script PHP
3962
05.10.2018 11:27
- [1034] Create index by sort failed
3528
06.03.2020 09:31
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.