Permissions Question - re-post - Mailing list pgsql-general

From Dan Wilson
Subject Permissions Question - re-post
Date
Msg-id 000201bed0ad$e4607980$9297fea9@dwilson
Whole thread Raw
List pgsql-general
This is a re-post because nobody ever responded.  I'm wondering if this is
supposed to be the case, otherwise it might want to be added to the todo.

-------------------------------------------------------------------------
I'm having a problem understanding the table level permissions.

I created a dummy user for individuals to sample a product connecting to my
database.

The product lists all database and tables within each database, however the
dummy account does not have any kind of permissions within the databases
other than the sample db.

Why are they able to list all the relations within the other databases?
Shouldn't this information be considered off limits to a user without select
permissions on the database?

I, personally, would prefer it that way.  Thus they cannot see the basic
structure of my "live" db's.

-Dan Wilson


pgsql-general by date:

Previous
From: hamann.w@t-online.de
Date:
Subject: pg_dump extension
Next
From: "Stephen Boyle"
Date:
Subject: Re: [GENERAL] Foreign Keys in PostgreSQL