Re: Password encryption in oracle_fdw extention

Thanks Laurenz.

Thanks,
Mukesh

On Sat, Mar 27, 2021, 3:47 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:

> On Fri, 2021-03-26 at 22:46 +0530, Mukesh Rajpurohit wrote:
> > I want to use encrypted oracle password in oracle_ fdw extention to
> connect to oracle.
> > But seems this option is not available in oracle_fdw. I know we can use
> oracle wallet
> > but in that too we have to configure plain text oracle password which
> we do not want to do.
> > Please suggest if any other alternate.
>
> I don't think you can use encrypted passwords with Oracle. Can you point
> me to
> documentation if that is not true?
>
> Anyway, if you don't want a password in the user mapping, the way to go is
> external authentication. You could use the "secure" external password
> store,
> which stores the encrypted password in a wallet, or you could use SSL
> certificate authentication.
>
> To use an external authentication method with oracle_fdw, specify an empty
> user name. Also, watch out: I am not an expert with Oracle's licencing
> policies
> (that would be a full time job), but you may need to pay extra if you want
> good
> security.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>