- Mais recentes
- Mais votos
- Mais comentários
Hi,
Did you exactly follow the guidance of the ref doc at https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Appendix.PostgreSQL.CommonDBATasks.Extensions.foreign-data-wrappers.html#postgresql-oracle-fdw ?
Also reading this post will be highly useful for you: https://aws.amazon.com/blogs/database/federated-query-support-for-amazon-aurora-postgresql-and-amazon-rds-for-postgresql-part-2/
Best,
Didier
It looks like user who is trying to build oracle_fdw doesn't have "write" permission on the directory where you unpacked the software, so it cannot create the file in that directory. Give the user permission and then try again
Sorry, I did not clarify where the error is coming from. It is from psql, so not during the installation or unpacking of the software.
Hi all,
After several Google searches
https://www.cybertec-postgresql.com/en/error-permission-denied-schema-public/
GRANT ALL ON SCHEMA public TO [username] ;
And it is working now.
This was mentioned on https://repost.aws/questions/QUfFqGdruLTna6sYRx3DFmdw/postgres-migration-10-6-11-1-permission-denied-for-schema-public. But I didn't think that is the answer as that link is not about oracle_fdw.
And had confirmed, it doesn't create the table on the Oracle side, I thought it has to, but obviously, the table has to exist on the Oracle side.
Would like to know if anyone else has more example or links to using oracle_fdw.
Hi,
FYI.
Just an update, on the Oracle end, if the grant is to a view, oracle_fdw doesn't work.
I have to do the grant to the table instead and then create a view on the table and then oracle_fdw is happy with it.
I was thinking of posting this as an issue but after thinking about it, this result appears to be the correct one, the extension is not supposed to check permission and expects the object being accessed is by that of the user's.
Conteúdo relevante
- AWS OFICIALAtualizada há um ano
Yeah, this is the one that I am following the link below, when I get the error and I have to do the GRANT TO PUBLIC SCHEMA
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Appendix.PostgreSQL.CommonDBATasks.Extensions.foreign-data-wrappers.html#postgresql-oracle-fdw