Subject Re: [Firebird-Architect] Counter proposal to Temporary tables
Author Alexandre Benson Smith
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
Id, Name
Connection = Current_Connection


see you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil