How does schema ownership relate to resolving PostgreSQL ANSI x64 ODBC error 13?

Responsive Ad Header

Question

Grade: Education Subject: Support
How does schema ownership relate to resolving PostgreSQL ANSI x64 ODBC error 13?
Asked by:
80 Viewed 80 Answers

Answer (80)

Best Answer
(303)
The schema owner implicitly has all privileges on the schema and objects within it. If the user experiencing the error is *not* the schema owner, they will need explicit `GRANT` permissions, even if they own the table within the schema. Ensure the appropriate `USAGE` privilege is granted on the schema.