pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPassword encryption in oracle_fdw extention
5+ messages / 3 participants
[nested] [flat]
* Password encryption in oracle_fdw extention
@ 2021-03-26 17:16 Mukesh Rajpurohit <vivasvan1902@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Mukesh Rajpurohit @ 2021-03-26 17:16 UTC (permalink / raw)
To: pgsql-admin
Hi,
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.
Thanks
Mukesh
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Password encryption in oracle_fdw extention
@ 2021-03-27 07:50 legrand legrand <legrand_legrand@hotmail.com>
parent: Mukesh Rajpurohit <vivasvan1902@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: legrand legrand @ 2021-03-27 07:50 UTC (permalink / raw)
To: pgsql-admin
Hello Mukesh,
Oracle_fdw is not maintained by this group, but by Laurenz Albe / Cybertec
at https://github.com/laurenz/oracle_fdw.
You will get a better feedback after posting there :0)
Regards
PAscal
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Password encryption in oracle_fdw extention
@ 2021-03-27 07:53 Mukesh Rajpurohit <vivasvan1902@gmail.com>
parent: legrand legrand <legrand_legrand@hotmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Mukesh Rajpurohit @ 2021-03-27 07:53 UTC (permalink / raw)
To: legrand legrand <legrand_legrand@hotmail.com>; +Cc: pgsql-admin
Thanks PAscal.
Thanks,
Mukesh
On Sat, Mar 27, 2021, 1:20 PM legrand legrand <legrand_legrand@hotmail.com>
wrote:
> Hello Mukesh,
> Oracle_fdw is not maintained by this group, but by Laurenz Albe / Cybertec
> at https://github.com/laurenz/oracle_fdw.
> You will get a better feedback after posting there :0)
> Regards
> PAscal
>
>
>
> --
> Sent from:
> https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Password encryption in oracle_fdw extention
@ 2021-03-27 10:17 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Mukesh Rajpurohit <vivasvan1902@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2021-03-27 10:17 UTC (permalink / raw)
To: Mukesh Rajpurohit <vivasvan1902@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Password encryption in oracle_fdw extention
@ 2021-03-27 10:26 Mukesh Rajpurohit <vivasvan1902@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 5+ messages in thread
From: Mukesh Rajpurohit @ 2021-03-27 10:26 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin
Thanks Laurenz.
Thanks,
Mukesh
On Sat, Mar 27, 2021, 3:47 PM Laurenz Albe <laurenz.albe@cybertec.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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2021-03-27 10:26 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-26 17:16 Password encryption in oracle_fdw extention Mukesh Rajpurohit <vivasvan1902@gmail.com>
2021-03-27 07:50 ` legrand legrand <legrand_legrand@hotmail.com>
2021-03-27 07:53 ` Mukesh Rajpurohit <vivasvan1902@gmail.com>
2021-03-27 10:17 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-03-27 10:26 ` Mukesh Rajpurohit <vivasvan1902@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox