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