Re: Different views with same name for different users

On Wed, Jan 16, 2002 at 02:21:39PM +0100, Harald Massa wrote:
> i've got a table of around 10.000 records.
>
> Users A, B, C are allowed to see all the records
>
> user D only some
> user E only some others
>
> Which is the most elegant way to do this?
> (is there any way at all????)

You cannot create different views with the same name in one PostgreSQL
database.  Hence the first answer is: there is no way.

Nevertheless that's not the right answer. You can create only one view:

   CREATE VIEW PERS as SELECT * FROM TOTALDATABASE where (criteria)

Within criteria you can check the user (`current_user') and return
`true' or `false' depending on the record at hand and the current
user.

--
Holger Krug
hkrug@rationalizer.com