Re: PgAdmin browses all tables, even those not allowed

Le 19/01/2010 13:36, F T a écrit :
> Hello list,
> 
> I use pgAdmin1.10.0, Windows XP, PostgreSQL 8.2.
> 
> If I connect to my database with pgAdmin,  using a connexion role that is
> not allowed to access some tables, I see thoses tables in the list (but I
> get a right error if I click it).
> 
> Is there a solution that pgAdmin shows a table list with only the tables the
> connexion role is allowed to access?
> 

Right now, we display every tables available in the database. There are
no security issues here, you'l have the same issue with psql.

However, it doesn't feel right to show tables and gets errors with a
simple click on it. I'm not sure the best way to deal with this is to
hide the tables (should we also hide the columns if the user is not
allowed to access some of them?). Actually, I think we need to better
handle this, but this will be a big work. Interesting, but lots of work.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com