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
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.