CCC Data Warehouse Controls
Controls for Data Warehouse technologies, as defined by the FINOS Common Cloud Controls project.
- ID
- CCC.DataWar.CN
- Version
- v2026.06-rc4
- Gemara version
- v1.2.0
- Author
- FINOS Common Cloud Controls
Access Control
The Access Control group covers entries related to authentication, authorization, and trust perimeter enforcement. This includes multi-factor authentication, least privilege access, network access rules, and prevention of unauthorized access or reconnaissance.
CCC.DataWar.CN01 Enforce Use of Managed Views for Data Access
Objective
Ensure that data access is provided through managed views, restricting users from accessing underlying tables directly and enforcing consistent security policies.
Assessment requirements
Attempt to access underlying database tables directly without using managed views and verify that access is denied.
Applicability: tlp-red, tlp-amber
Guidelines
- NIST-CSF
- PR.AC-4
- NIST_800_53
- AC-3
- AC-6
Threats
- CCC.Core.Threats
- CCC.Core.TH01
CCC.DataWar.CN02 Enforce Column-Level Security Policies
Objective
Ensure that access to sensitive data columns is restricted based on user roles, preventing unauthorized access to sensitive information.
Assessment requirements
Attempt to query sensitive columns without the necessary permissions and verify that access is denied or data is masked.
Applicability: tlp-red, tlp-amber
Guidelines
- NIST-CSF
- PR.AC-4
- NIST_800_53
- AC-3
- AC-6
Threats
- CCC.Core.Threats
- CCC.Core.TH01
CCC.DataWar.CN03 Enforce Row-Level Security Policies
Objective
Ensure that access to data rows is restricted based on user roles or attributes, preventing unauthorized access to specific subsets of data.
Assessment requirements
Attempt to query data rows that the user should not have access to and verify that access is denied or data is not returned.
Applicability: tlp-red, tlp-amber
Guidelines
- NIST-CSF
- PR.AC-4
- NIST_800_53
- AC-3
- AC-6
Threats
- CCC.Core.Threats
- CCC.Core.TH01