From: Oli Sennhauser <oli.sennhauser@bluewin.ch>
To: pgsql-admin@postgresql.org
Subject: Re: Opinion wanted: Default select rights for users via public
Date: Fri, 26 Dec 2003 15:39:00 +0100
Message-ID: <3FEC4804.4040500@bluewin.ch> (raw)
In-Reply-To: <16039.1072106469@sss.pgh.pa.us>
References: <3FE6D378.3020008@bluewin.ch>
<16039.1072106469@sss.pgh.pa.us>
Hello Tom
Thank you for answering.
>>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.
>
>
I see. But sometimes your solution is not possible. E.g. if I have a
critical application (banking?) and several kind of users on it. Some
users should NOT know, what is also around them but they have to use the
application. And if they know little about the rdbms they will find
things, they should not know, and they will be interested in and they
will search for knowing what is in, and so on....
In my opinion this is a (dd) design error done longe time ago. Now it
depends where do we want to go with PostgreSQL. In my opinion with this
"bug" (and some others) we will allways have the image of "little boys
(and girls) playing little around with rdbms.
Would it not be possible, e.g. to say we have a new interface now (e.g.
pg_tables, user_tables, all_tables and so on) and application should now
use the new interface and the old interface will outage in 2 or 3 years.
Otherwise we will never get rid of this problems.
Thanks for discussing
Oli
-------------------------------------------------------
Oli Sennhauser
Database-Engineer (Oracle & PostgreSQL)
Rebenweg 6
CH - 8610 Uster / Switzerland
Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14
e-Mail oli.sennhauser@bluewin.ch
Website http://mypage.bluewin.ch/shinguz/PostgreSQL/
Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID:
http://www.swisssign.ch
Import the SwissSign Root Certificate:
http://swisssign.net/cgi-bin/trust/importAttachments:
smime.p7s (application/x-pkcs7-signature, 3.4K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: oli.sennhauser@bluewin.ch
Subject: Re: Opinion wanted: Default select rights for users via public
In-Reply-To: <3FEC4804.4040500@bluewin.ch>
References: <3FE6D378.3020008@bluewin.ch> <16039.1072106469@sss.pgh.pa.us> <3FEC4804.4040500@bluewin.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox