Re: [ADMIN] Security Problem

2003-10-14 Thread Andrew Sullivan
On Tue, Oct 14, 2003 at 11:32:03AM +0200, Daniel Rubio wrote: > How I could solve this? Upgrade to 7.3 and use the schema support to do it for you. A -- Andrew Sullivan 204-4141 Yonge Street Afilias CanadaToronto, Ontario Canada <[EMAIL PROTE

Re: [ADMIN] Security Problem

2003-10-14 Thread Tom Lane
Daniel Rubio <[EMAIL PROTECTED]> writes: > I'm mantaining a Postgres installation on an ISP, and I see a relativly > important security issue. > I can connect to postgres with a normal user login and take a look to > the database structure of all the other databases on the installation. That is

Re: [ADMIN] Security Problem

2003-10-14 Thread Jeff
On Tue, 14 Oct 2003, Daniel Rubio wrote: > And I still can to look at the others database structure (connecting as > a non privileged user) ... > Did you try setting search_path in postgresql.conf to just '$user'? You'll also need a schema for each user. perhaps db_user_namespace does this? I di

[ADMIN] Security Problem

2003-10-14 Thread Daniel Rubio
Hi to all I'm mantaining a Postgres installation on an ISP, and I see a relativly important security issue. I can connect to postgres with a normal user login and take a look to the database structure of all the other databases on the installation. This is very visual with PGadmin. I connect a