From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Accessing dblink without using username and Password
Date: Tue, 11 Jan 2022 09:07:02 +0100
Message-ID: <d2cceed9-dd21-e4a4-cca2-568b3852e679@jakobs.com> (raw)
In-Reply-To: <CALfOM6LCyuMP5wHpt65WxK2A7WqH09JYwGXgx_hGtVa-AuBJKA@mail.gmail.com>
References: <CALfOM6LCyuMP5wHpt65WxK2A7WqH09JYwGXgx_hGtVa-AuBJKA@mail.gmail.com>
Am 11.01.22 um 08:25 schrieb Daulat:
> Hello Team,
>
> I need to know how we can access table data from a locally or remote
> database using dblink and without giving username and password.
> In the hba.conf file, md5 is allowed for all connections.
>
> It looks like we can do this approach using superuser but not from the
> normal users.
>
> Here, I have tried to access the data of one table from a database
> created locally.
>
> [postgres@ip-172-31-32-99 bin]$ ./psql -d Performance_DB_104_28MAR21
> -U trumos
> psql (10.2)
> Type "help" for help.
>
> Performance_DB_104_28MAR21=> show search_path;
> search_path
> -----------------
> "$user", public
> (1 row)
>
> Performance_DB_104_28MAR21=> SELECT * FROM
> ucf.dblink('dbname=DemoDB','SELECT processstatusid,createdby FROM
> ucf.ucf_processstatus') AS t1 (processstatusid integer, createdby
> integer);
> ERROR: password is required
> DETAIL: Non-superusers must provide a password in the connection string.
> Performance_DB_104_28MAR21=>
>
> Please suggest !
Hallo Daulat,
What about using certificates? If you already have a PKI infrastructure,
you can use these. Otherwise, you can use OpenSSL to create a
certification authority and the key pairs.
Btw, the dblink module has been superceded by foreign data wrappers.
Regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Accessing dblink without using username and Password
In-Reply-To: <d2cceed9-dd21-e4a4-cca2-568b3852e679@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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