>>>Keeping data for all subscibers in common tables will make life a lot easier for reporting. For example, what if you want to know the total value of all orders for all subscribers for a given month? Much easier if the data for all subscribers are in the same tables.
>>
>>
>>Maybe, but, as a customer, I wouldn't like that other customers can see at my data via SQL. I think that , for security reasons, separate data groups will be the way to go.
>
>No matter what type of backend you're using, you can use either a parameterized view, or a SPT string, both of which will contain the subscriber ID as a parameter. The user will only get back records that belong to him.

Hi Al.

Correct me if I'm wrong, but I think that scheme is easier to hack, since the user can access all the table information, making his calls outside the application.

Regards,