Re: [HACKERS] Here it is - view permissions

Brett McCormick <brett@work.chicken.org>

From: Brett McCormick <brett@work.chicken.org>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: olly@lfix.co.uk (Oliver Elphick), pgsql-hackers@hub.org
Date: 1998-02-23T23:06:32Z
Lists: pgsql-hackers
So I've never gotten the distinction -- what makes postgreSQL an
object oriented database, aside from the oid attribute and class
inheritance (which could work a little better.. no way to find out the
child class of a tuple in a select from parent_class* query).

and what makes it relational?  the fact that it can do joins?

in confused delerium,
--brett

On Mon, 23 February 1998, at 17:35:09, Bruce Momjian wrote:

> Will be the default in 6.3, I think.
>  
> > the table or even discover that it exists!
>                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> 
> Not in 6.3, or maybe ever.  Too much OO stuff for that, I think.
> 
> > 
> > It certainly seems undesirable to give automatic access to data of unknown
> > sensitivity.  Surely the default permission should be for the table's
> > creator alone or for the owner of the PostgreSQL database (which I suppose 
> > is equivalent to the `schema').
> > 
> > I see that Jan Wieck has posted a method for preventing world readability;
> > perhaps this should just be flagged as a configurable option.
> 
> 
> -- 
> Bruce Momjian                          |  830 Blythe Avenue
> maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
>   +  If your life is a hard drive,     |  (610) 353-9879(w)
>   +  Christ can be your backup.        |  (610) 853-3000(h)