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.

Consequently:

• 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.