On Wed, Jun 23, 2004 at 09:03:37AM +0200, "Krei�l, Karsten" wrote:
> But, under this conditions we must specify username and password > (without encryption!) in the view definition. Every user can read > this information using pgadmin or other tools. It's very simple ! In > our environment the remote DB knows the same users as our local DB. So > we are always searching for a solution, without publishing username > and password. Our background is a migration from INFORMIX DB to > PostgreSQL. Using INFORMIX there is a rather simple solution for this > problem, called Synonyms. Personally, I think it's a very bad idea to use a different database for this kind of data exchange. I'd go with using different schemas. There's a lot more fine grained control on access privileges, and users won't be able to see any password; also, the performance should be much better. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "El n�mero de instalaciones de UNIX se ha elevado a 10, y se espera que este n�mero aumente" (UPM, 1972) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
