At 02:42 PM 5/4/01 -0400, you wrote:

>How bout a view that can select from a stored procedure.
>This would allow you to put whatever logic you wish into the stored

procedure.

>With the view triggers you can make the view updateable.
>With extra global variables you can manipulate the view however you wish
>(base it on time of day, role, user name, ip address etc)
>
>>From what I understand, this would be the easiest and most flexible

approach.

>
>You give each client access to the view, not the table.
>

A join of a stored procedure can't be optimized. A view doesn't
have the computational power. Having the retrieval semantics in
the stored procedure and the update semantics in view triggers
doesn't strike me as particularly elegant, but not a show
stopper.

Jim Starkey