> **For AI agents:** The documentation index is at [https://docs.digitalocean.com/llms.txt](https://docs.digitalocean.com/llms.txt). Markdown versions of pages use the same URL with `index.html.md` in place of the HTML page (for example, append `index.html.md` to the directory path instead of opening the HTML document).

# How do I fix a "permission denied for schema public" error in my dev database?

In an App Platform dev database, an `ERROR: permission denied for schema public` error usually happens when the app’s deployment fails.

During the deployment process, App Platform grants the dev database user the necessary permissions to access the public schema. However, if the deployment fails, the user does not receive the permissions, resulting in the error. This can also cause the database to become stuck on `connection string is being provisioned`.

To resolve this issue, first delete the existing dev database and deploy the app, ensuring the deployment completes successfully. Then create a new dev database and deploy the app again, making sure the deployment is successful.

## Related Topics

[How do I fix the error "Record is managed by an App on this account, and cannot be deleted"?](https://docs.digitalocean.com/support/how-do-i-fix-the-error-record-is-managed-by-an-app-on-this-account-and-cannot-be-deleted/index.html.md): Use the app’s Settings tab to remove domains associated with App Platform apps.

[Why do I get the error “JavaScript heap out of memory” during deployment?](https://docs.digitalocean.com/support/why-do-i-get-the-error-javascript-heap-out-of-memory-during-deployment/index.html.md): Increase the heap memory by setting the environment variable NODE\_OPTIONS=–max-old-space-size=4096.

[Why do I get the error "Domain Already Exists" when trying to add a domain to an app in another account?](https://docs.digitalocean.com/support/why-do-i-get-the-error-domain-already-exists-when-trying-to-add-a-domain-to-an-app-in-another-account/index.html.md): You cannot add the same domain name to multiple apps or split an app and domain name across more than one account.