Secure Data Access
Data Connectivity typically occurs with an application login.
The authenticated userid is delivered to the data layer as a special parameter userid.
This userid is used to filter returned datasets (e.g., an additional WHERE clause in a SQL query.
As a parameter any cache on the server for frequently accessed data then becomes user specific.
The underlying data repositories will need a mapping table for userid's datasets.