Check: DG0138-SQLServer9
Database SQL Server 9:
DG0138-SQLServer9
(in version v8 r1.9)
Title
Access grants to sensitive data should be restricted to authorized user roles. (Cat II impact)
Discussion
Unauthorized access to sensitive data may compromise the confidentiality of personnel privacy, threaten national security or compromise a variety of other sensitive operations. Access controls are best managed by defining requirements based on distinct job functions and assigning access based on the job function assigned to the individual user.
Check Content
If no data is identified as being sensitive or classified by the Information Owner, in the System Security Plan or in the AIS Functional Architecture documentation, this check is Not a Finding. If no identified sensitive or classified data requires encryption by the Information Owner in the System Security Plan and/or AIS Functional Architecture documentation, this check is Not a Finding. Review data access requirements for sensitive data as identified and assigned by the Information Owner in the System Security Plan. Review the access controls for sensitive data configured in the database. If the configured access controls do not match those defined in the System Security Plan, this is a Finding.
Fix Text
Define, document and implement all sensitive data access controls based on job function in the System Security Plan.
Additional Identifiers
Rule ID: SV-25369r1_rule
Vulnerability ID: V-15642
Group Title:
Expert Comments
CCIs
Number | Definition |
---|---|
No CCIs are assigned to this check |
Controls
Number | Title |
---|---|
No controls are assigned to this check |