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.
>
>
>--
>Aage J.
>
>

Create view MyView (ID, Name) as
select
Id, Name
from
MyTable
where
Connection = Current_Connection

???

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br