# Postgres 'create schema abc'; fails with permission denied

**URL:** <https://community.ovhcloud.com/t/postgres-create-schema-abc-fails-with-permission-denied/28102>\
**Category:** Oldies but goldies\
**Created:** [Août 29, 2020, 6:16 UTC](https://community.ovhcloud.com/t/postgres-create-schema-abc-fails-with-permission-denied/28102 "2020-08-29T18:16:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DavidH23](https://community.ovhcloud.com/letter_avatar/davidh23/32/6_449c533f586939b6e5f246632a46421f.png) [@DavidH23](https://community.ovhcloud.com/u/DavidH23)\
**Post date:** [Août 29, 2020, 6:16 UTC](https://community.ovhcloud.com/t/postgres-create-schema-abc-fails-with-permission-denied/28102/1 "2020-08-29T18:16:12Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ChristianG32](https://community.ovhcloud.com/letter_avatar/christiang32/32/6_449c533f586939b6e5f246632a46421f.png) [@ChristianG32](https://community.ovhcloud.com/u/ChristianG32)\
**Post date:** [Février 26, 2021, 2:11 UTC](https://community.ovhcloud.com/t/postgres-create-schema-abc-fails-with-permission-denied/28102/2 "2021-02-26T14:11:35Z")

</div>

Same problem here. Did you found a solution?

---

<div class="post-metadata">

**Author:** ![LanceJ](https://community.ovhcloud.com/letter_avatar/lancej/32/6_449c533f586939b6e5f246632a46421f.png) [@LanceJ](https://community.ovhcloud.com/u/LanceJ)\
**Post date:** [Mars 1, 2021, 8:48 UTC](https://community.ovhcloud.com/t/postgres-create-schema-abc-fails-with-permission-denied/28102/3 "2021-03-01T08:48:05Z")

</div>

same problem as before

---

<div class="post-metadata">

**Author:** ![MathieuG16](https://community.ovhcloud.com/letter_avatar/mathieug16/32/6_449c533f586939b6e5f246632a46421f.png) [@MathieuG16](https://community.ovhcloud.com/u/MathieuG16)\
**Post date:** [Mars 3, 2021, 9:03 UTC](https://community.ovhcloud.com/t/postgres-create-schema-abc-fails-with-permission-denied/28102/4 "2021-03-03T09:03:53Z")

</div>

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.
