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.


--
Aage J.