I have created an external list which is drawing data from a single table in an Azure SQL Database (SAAS). Two external content type operations: List & Read Item.
This is a generic list containing information for all employees in the company such as name, position, work location, etc. This list is used in a couple of ways : 1. To allow users to search employees for use in forms, workflow etc (cant use user profile service as not all employees are online) 2. To act as the source for an off the shelf SharePoint App that displays the org charts
Currently all data in this list is public, so confidentiality is not an issue. We have just had a request from HR to include some additional data that is confidential (such as date of birth).
Before I proceed, any advice on securing just the confidential columns? My current thoughts are to have two separate lists...