Re: oracle_fdw with oracle os authentication

Поиск
Список
Период
Сортировка
От Xiong He
Тема Re: oracle_fdw with oracle os authentication
Дата
Msg-id tencent_7C28669C0CC3D15D3BD9B89C@qq.com
обсуждение исходный текст
Ответ на oracle_fdw with oracle os authentication  (Papiernik Anna-AAP053 <anna.papiernik@motorolasolutions.com>)
Список pgsql-general
Дерево обсуждения
Not sure. But you can always avoid the OS authentication with empty user and password to access Oracle.
You can use other authentication mode to access oracle instead.

------------------
Thanks&Regards,
Xiong He

 


------------------ Original ------------------
From:  "Papiernik Anna-AAP053"<anna.papiernik@motorolasolutions.com>;
Date:  Tue, Oct 23, 2012 06:07 PM
To:  "pgsql-general@postgresql.org"<pgsql-general@postgresql.org>;
Subject:  [GENERAL] oracle_fdw with oracle os authentication

<!-- @font-face{font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} p.MsoNormal, li.MsoNormal, div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";} p.MsoAcetate, li.MsoAcetate, div.MsoAcetate{mso-style-priority:99;mso-style-link:"Balloon Text Char";margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma","sans-serif";} span.EmailStyle17{mso-style-type:personal-compose;font-family:"Calibri","sans-serif";color:windowtext;} span.BalloonTextChar{mso-style-name:"Balloon Text Char";mso-style-priority:99;mso-style-link:"Balloon Text";font-family:"Tahoma","sans-serif";} .MsoChpDefault{mso-style-type:export-only;} @page WordSection1{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1{page:WordSection1;} -->

I have Oracle with OS authentication.

And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database.

 

I have performed steps:

CREATE EXTENSION oracle_fdw;

CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver '');

GRANT USAGE ON FOREIGN SERVER oradb TO postgres;

CREATE USER MAPPING FOR postgres SERVER oradb OPTIONS (user '', password '');

 

Then I have created foreign table and I want to select from it.

Unfortunatelly, oracle_fdw is unable to connect using OS authentication and it doesn’t work.

 

Is it possible to use oracle_fdw to have OS authentication?

 

Regards,
Anna

В списке pgsql-general по дате отправления: