Re: Opinion wanted: Default select rights for users via public schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Opinion wanted: Default select rights for users via public schema
Date: 2003-12-22 15:21:09
Message-ID: 16039.1072106469@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sai Hertz And Control Systems 2003-12-22 15:58:23 Unix 2038 And PostgreSQL
Previous Message Tom Lane 2003-12-22 15:15:06 Re: CREATE USER system privilege?