Aage Johansen wrote:

>Alexandre Benson Smith wrote:
> >> ...
> >>With "conventional table" one will need well-behaved clients who won't
> >>read/change or otherwise muck around in data that doesn't belong to them.
> >
> >
> > If one revokes the select/insert/update/delete rows from table and grant
> > it to the filtered view, there isno chance to one user see others data,
> > or mess up with them.
>
>
>As each new connection will use a new "connection identifier", one will
>need to create a new view for each connection. If so, this will be messy.
>
>
>

If Nickolay implements connection attributes, one view will suffice for
all users. The only piece necessary is something to set the connection
attribute with a unique value. I don't see any reason that a generator
wouldn't do the trick.

--

Jim Starkey
Netfrastructure, Inc.
978 526-1376