AW: New SQL Datatype RECURRINGCHAR

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: AW: New SQL Datatype RECURRINGCHAR
Date: 2001-07-09 10:31:23
Message-ID: 11C1E6749A55D411A9670001FA68796336836D@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> My feeling is that the restrictions are stringent enough to eliminate
> most of the interesting uses of views, and hence an automatic rule
> creation feature is not nearly as useful/important as it appears at
> first glance.

The most prominent of the "interesting uses" probably beeing when the views
are part of the authorization system, since views are the only standardized
mechanism to restrict access at the row level. Imho not to be neglected.
(user xxx is only allowed to manipulate rows that belong to his department,
so he is only granted access to a view, not the main table)

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2001-07-09 11:39:19 Re: AW: New SQL Datatype RECURRINGCHAR
Previous Message Justin Clift 2001-07-09 02:44:52 Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword