Postgres 'create schema abc'; fails with permission denied
BMPCreated with Sketch.BMPZIPCreated with Sketch.ZIPXLSCreated with Sketch.XLSTXTCreated with Sketch.TXTPPTCreated with Sketch.PPTPNGCreated with Sketch.PNGPDFCreated with Sketch.PDFJPGCreated with Sketch.JPGGIFCreated with Sketch.GIFDOCCreated with Sketch.DOC Error Created with Sketch.
question

Postgres 'create schema abc'; fails with permission denied

Par
DavidH23
Créé le 2020-08-29 18:16:12 (edited on 2024-09-04 14:05:58) dans Bases de données



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


3 réponses ( Latest reply on 2021-03-03 09:03:53 Par
MathieuG16
)

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.

Les réponses sont actuellement désactivées pour cette question.