pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/import

Attachments:

  smime.p7s (application/x-pkcs7-signature, 3.4K) download

view thread (4+ messages)  latest in thread

Message-ID: <3FEC4804.4040500@bluewin.ch>
Permalink:  ../3FEC4804.4040500@bluewin.ch/
Also on:    postgresql.org/message-id/3FEC4804.4040500@bluewin.ch

 · 

reply

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