How To Grant Permission On Foreign Data Wrapper

We can read data from Oracle or MSSQL with the help of PostgreSQL Foreign Data Wrapper. Please read the following articles for installation and detailed information.

Foreign Data Wrapper Between PostgreSQL and Oracle“,

Foreign Data Wrapper Between PostgreSQL and MSSQL

You have created oracle_fdw(Oracle Foreign Data Wrapper Extension) or tds_fdw(MSSQL Foreign Data Wrapper Extension) in the PostgreSQL Cluster. In order to enable the application developer to perform his / her own operations on Oracle_fdw or tds_fdw, you can authorize the user as follows.

Faruk Erdem
Author: Faruk Erdem

Leave a Reply

Your email address will not be published. Required fields are marked *