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.org http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support