Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>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,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement