DBLink's default user: postgres

From: "Rodrigo Hjort" <rodrigo(dot)hjort(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: DBLink's default user: postgres
Date: 2007-10-17 13:07:13
Message-ID: 731083980710170607hb7b4931h198d1b73b67f1f20@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Is this the regular behavior on DBLink?

rot=> SELECT user, current_database();
current_user | current_database
--------------+------------------
sa_rot | rot
(1 registro)

rot=> SELECT *
rot-> FROM dblink('dbname=escola',
rot(> 'SELECT user, current_database()')
rot-> AS (usr name, db name);
usr | db
----------+--------
postgres | escola
(1 registro)

This way, I fear DBLink functions should become a vulnerability issue on my
database.
Is there any way to protect or override this setting? Or it should be done
on pg_hba.conf only?

--
Regards,

Rodrigo Hjort
http://icewall.org/~hjort

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-10-17 13:42:45 Re: Why copy_relation_data only use wal when WALarchiving is enabled
Previous Message Florian G. Pflug 2007-10-17 13:06:08 Re: Why copy_relation_data only use wal when WALarchiving is enabled