Should info from the data warehouse be available to all employees?
There is absolutely NNo reason for data of any sort to be made available to all employees. Attempting to make such an argument is basically saying that the company has decided to avoid taking on the responsibility of protecting and securing data appropriately. Every piece of data that is important enough for an organization to collect and maintain is important enough to be secured and protected properly. This means that only those people within the organization who have a business requirement to access the data should be permitted to access it. All other access should be denied using the security mechanisms of the DBMS and/or add-on security software.
