Re: dblink for 8.4 should work without user-mappings - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: dblink for 8.4 should work without user-mappings
Date
Msg-id 200906241307.52886.peter_e@gmx.net
Whole thread Raw
In response to dblink for 8.4 should work without user-mappings  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
On Wednesday 24 June 2009 05:42:01 Itagaki Takahiro wrote:
> contrib/dblink in 8.4 supports a server name by CREATE SERVER for
> connection string, but it always requires an user-mapping (by CREATE USER
> MAPPING). However, I think it should work user-mappings because it works
> when the connection string is passed directly.

I had looked into this the other day.  I *think* that SQL/MED requires a user 
mapping to be present.  There are cases where either behavior might be useful, 
but we should think about this carefully.  It's not simply a question of 
security, as you appear to imply.



pgsql-hackers by date:

Previous
From: Boszormenyi Zoltan
Date:
Subject: ECPG dynamic cursor, SQLDA support
Next
From: Stephen Frost
Date:
Subject: Re: [PATCH] backend: compare word-at-a-time in bcTruelen