Re: Opinion wanted: Default select rights for users via public schema - Mailing list pgsql-admin

From Tom Lane
Subject Re: Opinion wanted: Default select rights for users via public schema
Date
Msg-id 16039.1072106469@sss.pgh.pa.us
Whole thread Raw
In response to Opinion wanted: Default select rights for users via public schema  (Oli Sennhauser <oli.sennhauser@bluewin.ch>)
Responses Re: Opinion wanted: Default select rights for users via public  (Oli Sennhauser <oli.sennhauser@bluewin.ch>)
List pgsql-admin
Oli Sennhauser <oli.sennhauser@bluewin.ch> writes:
> I found that all users have access to pg_class etc. by default. In my
> opinion this causes some security questions or at least can make users
> curious about things they should not.

This isn't going to change, because it would break too many clients
(as indeed you just found out).  Give users their own databases if you
feel you need that much separation.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE USER system privilege?
Next
From: Sai Hertz And Control Systems
Date:
Subject: Unix 2038 And PostgreSQL