Subscribe Now
Trending News
10 Jun 2023
Foreign Data Wrapper, Oracle, oracle_fdw, PostgreSQL, Secure External Password Store, Security

PostgreSQL’s foreign data wrapper to Oracle: hide passwords using secure external password store 

Hi there, customer is worried about the credentials that are stored in PostgreSQL dbwhen using foreign data wrappers. In that case to Oracle, using oracle_fdw.It is possible to query a stored password from data dictionary. Only privileged users can do it, but still kind of…

Oracle, Oracle NET

TNS chaos 

I like to have my Oracle Net config consistent and without surprises. So for me it is a best practice to have ONE central TNS_ADMIN directory on the database server, which is set in all my shells. But a lot of processes might ignore that…

Uncategorized

Why this Blog? 

I had a blog, so why a new one? … Cause the old one was maintained by Trivadis – my employer – and just disappeared. Some customers and friends just asked me about that content. Thank you, that you consider it valuable. As it seems…

Uncategorized

My First Blog Post 

…. coming soon … Be yourself; Everyone else is already taken. — Oscar Wilde. This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Subscribe below to get notified when I post new updates.