Re: [HACKERS] Here it is - view permissions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Here it is - view permissions
Date
Msg-id 199802241509.KAA05955@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Here it is - view permissions  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
>
> Andreas wrote:
> >
> > >> the table or even discover that it exists!
> > >               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> > > Not in 6.3, or maybe ever.  Too much OO stuff for that, I think.
> >
> > I vote for not ever. No commercial DBMS has it. It is a standard
> > that is of very restricted practicability. You can always split into
> > different
> > databases whatever needs turbo security.
>
>     I'm not quite sure if any commercial RDMBS does it. But since
>     we don't have the ability to create multiple tables/views  of
>     the  same  name  as  long  as the owner differs, I think it's
>     better to stay as we  are.   As  long  as  PostgreSQL  cannot
>     distinguish  tables  of  the  same name by a <user>.tablename
>     syntax, it's better to let  them  know  what  tables  already
>     exist.

I have NOT added this to the TODO list.

--
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)

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Views on aggregates - need assistence
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'