linuxkathirvel/django-permission-denied-for-relation.md

Created October 15, 2020 16:35

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/linuxkathirvel/3321d4f4035c169d23dd240886c3e2e1.js"></script>
Save linuxkathirvel/3321d4f4035c169d23dd240886c3e2e1 to your computer and use it in GitHub Desktop.

Download ZIP

How to solve "django.db.utils.ProgrammingError: permission denied for relation"?

Raw

django-permission-denied-for-relation.md

How to solve "django.db.utils.ProgrammingError: permission denied for relation"?

sudo su postgres
psql mydatabase -c "GRANT ALL ON ALL TABLES IN SCHEMA public to dbuser;"
psql mydatabase -c "GRANT ALL ON ALL SEQUENCES IN SCHEMA public to dbuser;"
psql mydatabase -c "GRANT ALL ON ALL FUNCTIONS IN SCHEMA public to dbuser;"

References

https://stackoverflow.com/questions/38944551/steps-to-troubleshoot-django-db-utils-programmingerror-permission-denied-for-r