NeonN
Neon2mo ago
2 replies
scattered-teal

ERROR: permission denied for schema rag_bge_small_en_v15

Hi folks, I tried following https://neon.com/docs/extensions/pg-extensions#install-an-extension and https://neon.com/docs/manage/roles#manage-roles-with-sql
but I can't seem to set the correct permissions for a role following least-privileges.
The extension is owned by cloud_admin, and neondb_owner cannot grant usage on schema rag_bge_small_en_v15 to person;

Am I missing something?

PS: more details on the exact procedure are listed here: https://github.com/docteurklein/httpg/blob/main/sql/cpres.sql#L5-L52
GitHub
http hypermedia server for postgres. Contribute to docteurklein/httpg development by creating an account on GitHub.
httpg/sql/cpres.sql at main · docteurklein/httpg
Neon
In Neon, roles are Postgres roles. Each Neon project is created with a Postgres role that is named for your database. For example, if your database is named neondb, the project is created with a role ...
Manage roles - Neon Docs
Neon
Neon supports the Postgres extensions shown in the following table. The supported version of the extension sometimes differs by Postgres version. A dash ( ) indicates that an extension is not yet supp...
Supported Postgres extensions - Neon Docs
Was this page helpful?