Security Problem

Поиск
Список
Период
Сортировка
Искать

Security Problem

От:
Daniel Rubio <drubior@tinet.org>
Дата:
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 as a simple user, and I 
can't create or select data from other's database, but i can see which 
databases exists on the system and look at the tables and columns of 
each of them (and i don't want it).

I've tried to solve it with:

REVOKE ALL PRIVILEGES ON DATABASE x FROM PUBLIC;
REVOKE ALL PRIVILEGES ON SCHEMA public FROM PUBLIC;
REVOKE ALL PRIVILEGES ON SCHEMA public FROM GROUP users;
...

And I still can to look at the others database structure (connecting as 
a non privileged user) ...

How I could solve this?

Thanks
-- 
********************************************************
Daniel Rubio Rodríguez
********************************************************

Re: Security Problem

От:
Jeff <threshar@torgo.978.org>
Дата:
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 didn't find much info on that.


--
Jeff Trout 
http://www.jefftrout.com/
http://www.stuarthamm.net/


Re: Security Problem

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Daniel Rubio  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 correct; we do not consider it a security problem.  If you don't
want a user to be able to look at the system catalogs of a database, you
need to disallow him from connecting to that database at all.  (See
pg_hba.conf for this, not GRANT/REVOKE.)

			regards, tom lane

Re: Security Problem

От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:
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 Canada                        Toronto, Ontario Canada
                              M2P 2A8
                                         +1 416 646 3304 x110

FAQ