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