Re: Accessing dblink without using username and Password

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(at)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