Permission Question - Mailing list pgsql-general

From Dan Wilson
Subject Permission Question
Date
Msg-id 003901becaa6$2ec077e0$078353d8@dwilson
Whole thread Raw
List pgsql-general
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.

Just asking....

-Dan Wilson



pgsql-general by date:

Previous
From: "Dan Wilson"
Date:
Subject: Compile Error
Next
From: Rachel Greenham
Date:
Subject: Re: [GENERAL] New FAQ item