Database & Information Security

Chapter 13
Privacy, Ethics, Compliance and Governance

Diploma in Cybersecurity
Database & Information Security   •   Diploma

Privacy, Ethics, Compliance and Governance

Introduction

Database and information security is not limited to preventing unauthorized access. Organisations also have responsibilities concerning why information is collected, how it is used, how long it is retained, who may access it, and what happens when something goes wrong. These responsibilities are expressed through privacy principles, professional ethics, legislation, regulatory requirements, contracts and governance frameworks.

Privacy is concerned with appropriate control over information about identifiable people. Information security protects confidentiality, integrity and availability, while privacy asks whether the collection and use of information is justified, transparent and fair. A database can therefore be technically secure but still violate privacy—for example, when an organisation collects excessive data, retains it indefinitely or uses it for an undisclosed purpose.

This chapter examines privacy principles, consent, purpose limitation, data-subject rights, retention, breach notification, ethical monitoring and governance. It also relates practical controls to ISO/IEC 27001, the NIST Cybersecurity Framework, CIS Controls and data-protection regulations. Laws differ by jurisdiction, so professionals must verify the legislation and regulator applicable to their organisation, sector and data subjects.

Learning Objectives

By the end of this chapter, students should be able to:

  1. Explain the difference between privacy, data protection, information security and ethics.
  2. Apply core privacy principles to database design and operational processes.
  3. Distinguish consent from other lawful bases for processing personal data.
  4. Explain data-subject rights, retention obligations and breach-notification processes.
  5. Relate privacy controls to ISO/IEC 27001, NIST and CIS frameworks.
  6. Evaluate ethical issues in employee monitoring, analytics and artificial intelligence.
  7. Propose a practical governance response to a privacy or compliance problem.

1. Privacy, Security, Ethics and Governance

Privacy concerns the appropriate collection, use, disclosure, storage and deletion of information relating to people. Personal data generally means information relating to an identified or identifiable person. Names, identity numbers, email addresses, precise location, online identifiers and biometric data may all be personal data, depending on context.

Information security is the protection of information and systems against unauthorised or harmful actions. Its classic objectives are:

  • Confidentiality: information is available only to authorised parties.
  • Integrity: information remains accurate, complete and protected from unauthorised alteration.
  • Availability: authorised users can access information when required.

Data protection is the legal and organisational discipline governing personal-data processing. Ethics concerns what ought to be done, including fairness, dignity, proportionality and avoidance of harm, even where an action may be technically legal. Governance provides direction, accountability, decision rights and oversight.

These concepts overlap but are not interchangeable. Encryption may support confidentiality, yet it does not justify collecting unnecessary information. A privacy notice may promote transparency, yet it does not prevent a database breach. Effective practice combines all four perspectives.

Important actors and terms

A data subject is the person to whom personal data relates. A controller or equivalent term is the organisation that determines the purposes and means of processing. A processor acts on behalf of the controller. A data protection officer or privacy officer advises on compliance and monitoring where required. A regulator supervises compliance and may investigate or impose sanctions.

Processing is a broad term that includes collecting, recording, organising, storing, analysing, sharing, altering and deleting data. A database administrator, software developer, business owner and security officer may all have different responsibilities in the same processing activity.

2. Core Privacy Principles

Although wording differs among laws, widely recognised privacy principles include the following.

Lawfulness, fairness and transparency

Processing should have a valid legal or organisational basis, should not unfairly disadvantage people and should be explained in clear language. A privacy notice should normally describe the categories of data collected, purposes, recipients, retention approach, rights and contact details.

Transparency is not achieved merely by publishing a long legal document. Information should be accessible at the time of collection and appropriate to the audience. A mobile application requesting contact lists, for example, should explain why that access is required before permission is requested.

Purpose limitation

Data should be collected for specified, explicit and legitimate purposes and should not later be used for incompatible purposes without a valid justification. A university collecting emergency contact information should not automatically use it for commercial advertising. Reuse may sometimes be permitted for compatible research, archiving or public-interest purposes, but this requires a documented assessment and appropriate safeguards.

Data minimisation

Only data reasonably necessary for the stated purpose should be collected. Minimisation reduces privacy exposure, storage costs and the impact of breaches. Developers should question every field in a form: Is it necessary? Can the service operate with less precision? Can an age range replace a date of birth? Can a token replace a payment-card number?

Accuracy

Incorrect personal data can cause financial, legal or personal harm. Organisations should provide ways to correct data and should consider the source, age and reliability of important records. Accuracy is especially significant in credit decisions, health records, employment systems and identity verification.

Storage limitation

Personal data should not be retained in identifiable form longer than necessary for its purpose or a legal obligation. Retention is not simply a technical backup issue. It requires a schedule, ownership, deletion rules, legal holds and verification that copies, replicas, exports and backups are addressed.

Integrity and confidentiality

Appropriate technical and organisational measures should protect data from unauthorised access, loss, destruction and alteration. Controls may include access management, encryption, logging, secure configuration, segregation of duties, backup protection, staff training and incident response.

Accountability

The organisation must be able to demonstrate compliance. Evidence includes records of processing, risk assessments, policies, contracts, training records, access reviews, deletion logs, incident records and audit results. Accountability changes privacy from an aspiration into an auditable management responsibility.

3. Lawful Processing and Consent

A common mistake is to treat consent as the universal basis for processing. Depending on the applicable law, processing may be justified by consent, contract, legal obligation, protection of vital interests, public task or legitimate interests. The available bases and their conditions vary by jurisdiction.

Valid consent is generally expected to be:

  • Freely given: refusal should not involve unfair pressure, and unnecessary services should not be conditional on consent.
  • Specific: consent should relate to a defined purpose rather than vague future uses.
  • Informed: people should understand what they are agreeing to.
  • Unambiguous or affirmative: silence or a preselected box is generally weak evidence of agreement.
  • Withdrawable: withdrawal should be practical and no more difficult than giving consent.

Consent is particularly sensitive where there is an imbalance of power, such as employer and employee. A worker may appear to agree to extensive monitoring but may not feel free to refuse. Organisations should assess whether another lawful basis is appropriate and whether the monitoring itself is necessary and proportionate.

Consent records should include who consented, when, the notice presented, the purposes, the method and any withdrawal. A database field such as consent = true is not sufficient evidence if the organisation cannot show what the person consented to.

4. Data-Subject Rights

Many data-protection regimes provide rights that require database and workflow support. Common rights include:

RightPractical implication
AccessLocate relevant records and provide a comprehensible copy, subject to lawful restrictions.
RectificationCorrect inaccurate or incomplete information.
ErasureDelete data when a recognised condition applies, subject to exceptions such as legal retention.
RestrictionTemporarily limit use while a dispute or legal issue is assessed.
PortabilityProvide certain data in a structured, commonly usable format where the law requires it.
ObjectionChallenge particular processing, including some direct marketing or legitimate-interest processing.
Review of automated decisionsObtain information or human involvement where legally required for significant automated decisions.

A rights process should include identity verification, request logging, search across systems, response deadlines, exception assessment, approval and evidence of completion. A fragmented architecture makes this difficult because personal data may exist in production databases, data warehouses, email, spreadsheets, SaaS platforms, logs and backups.

Identity verification must also be proportionate. Asking for excessive identity documents to process a simple request creates a new privacy risk. Access requests may need redaction to protect other people’s information, confidential sources or legally privileged material.

5. Privacy by Design and by Default

Privacy by design integrates privacy into architecture, development and procurement rather than adding it after deployment. Typical practices include:

  • collecting the minimum necessary attributes;
  • separating identity data from operational or analytical data;
  • using role-based access control and least privilege;
  • encrypting data in transit and at rest where appropriate;
  • pseudonymising data for testing and analytics;
  • applying secure deletion and retention automation;
  • recording access and administrative actions;
  • evaluating suppliers and data transfers;
  • testing privacy requirements before release.

Anonymisation aims to make re-identification reasonably impracticable, whereas pseudonymisation replaces direct identifiers but retains a possibility of re-identification using additional information. Pseudonymised data generally remains personal data when the organisation can reconnect it to a person.

Privacy impact assessments, sometimes called data protection impact assessments, are structured analyses of processing risks. They are especially appropriate for large-scale sensitive data, systematic monitoring, biometric identification, profiling or innovative technologies. A sound assessment identifies the processing, necessity, affected people, threats, possible harms, controls, residual risk and approval decision.

6. Retention, Disposal and Records Management

Retention must balance operational need, legal obligations, historical value and privacy risk. A retention schedule should state the record category, purpose, owner, retention period or trigger, disposal method, legal hold process and system locations.

Deletion should be meaningful. Removing a row from an application table may leave copies in replicas, caches, exports, analytical stores, audit trails and backups. Some records, such as security logs, may need to be retained for accountability, but access should be restricted and the period justified.

A legal hold suspends ordinary deletion when litigation, investigation or regulatory action is reasonably anticipated. Holds should be documented, scoped and released when no longer necessary. Indefinite retention without a documented reason is not a safe default.

Secure disposal may involve cryptographic erasure, controlled media destruction, verified overwriting or secure deletion commands, depending on the medium and risk. Disposal evidence should identify what was deleted, when, by whom or by which process, and how completion was verified.

7. Breach Management and Notification

A personal-data breach may involve unauthorised disclosure, access, alteration, loss or destruction. Examples include a stolen unencrypted laptop, misdirected email, compromised credentials, ransomware or an exposed cloud storage bucket.

A mature response process includes:

  1. Detection and reporting: identify suspicious activity and preserve initial evidence.
  2. Containment: disable accounts, isolate systems or restrict exposure without destroying evidence.
  3. Assessment: determine the data, people, systems, duration, cause and likely harm.
  4. Notification decision: consult applicable law, contracts, insurers and regulators. Some regimes require notification to a regulator within a specified period and notification to affected individuals when risk reaches a defined threshold.
  5. Remediation: remove the vulnerability, reset credentials, restore systems and reduce future exposure.
  6. Lessons learned: update controls, training, risk assessments and procedures.

Notification is a legal and risk decision, not merely a public-relations exercise. Delayed notification, unsupported assurances or concealment may increase harm and regulatory consequences. Organisations should maintain an incident register even when notification is not required, subject to applicable law.

8. Governance and Control Frameworks

Governance establishes who decides, who performs, who reviews and who is accountable. A useful model separates:

  • Board or executive leadership: approves risk appetite and provides resources.
  • Information-security and privacy leadership: develops policy, advises on risk and coordinates assurance.
  • Business and data owners: define purpose, classification, access and retention.
  • IT, database and application teams: implement and operate controls.
  • Legal, compliance and procurement: interpret obligations and manage contractual risk.
  • Internal audit or independent assurance: evaluates effectiveness.
  • All personnel: handle information according to policy and report concerns.

ISO/IEC 27001

ISO/IEC 27001 specifies requirements for an information security management system (ISMS). It uses a risk-based management cycle involving context, leadership, planning, support, operation, performance evaluation and improvement. The organisation identifies risks, selects controls, documents applicability and evaluates effectiveness. Annex A provides a catalogue of control themes, but certification is not achieved by implementing a checklist alone.

Privacy governance can be integrated into the ISMS through asset inventories, access control, supplier security, incident management, business continuity, logging, secure development and records of compliance. Privacy-specific management may also be supported by ISO/IEC 27701, where applicable.

NIST Cybersecurity Framework

The NIST Cybersecurity Framework 2.0 organises cybersecurity outcomes into Govern, Identify, Protect, Detect, Respond and Recover. The Govern function explicitly addresses organisational context, risk strategy, roles, policy, oversight and supply-chain risk. Privacy activities can be mapped across the functions: identify personal-data assets, protect them, detect misuse, respond to breaches and recover while preserving evidence and trust.

CIS Controls

CIS Controls provide prioritised, practical safeguards. Relevant examples include inventory of assets and software, data protection, secure configuration, account management, access control, audit-log management, vulnerability management, incident response and security awareness. They are useful operational guidance, but organisations must still determine legal duties and context-specific privacy requirements.

Frameworks support compliance; they do not replace law. A control is effective only when it is implemented, correctly configured, monitored and reviewed.

9. Ethical Monitoring and Responsible Data Use

Employee monitoring may include login records, email inspection, endpoint telemetry, location tracking, keystroke logging, productivity analytics or camera systems. Monitoring can support security and safety, but it may also create stress, discrimination, function creep and unjustified surveillance.

An ethical monitoring decision should ask:

  1. What legitimate problem is being addressed?
  2. Is monitoring necessary, or can a less intrusive method work?
  3. Is the scope proportionate to the risk?
  4. Are people informed in understandable terms?
  5. Who can access the results?
  6. How long are records kept?
  7. Could the data produce unfair decisions or discrimination?
  8. Is there human review and a way to challenge an outcome?

Security monitoring should focus on indicators relevant to security rather than collecting unrelated personal detail. Access to monitoring data should be restricted, logged and independently reviewed. Managers should not automatically equate activity metrics with performance; such metrics may be misleading and can reward undesirable behaviour.

Artificial intelligence introduces further concerns. Training data may contain personal information, historical bias or confidential material. Outputs may be inaccurate, difficult to explain or used beyond the original purpose. Responsible use requires data provenance, necessity assessment, access controls, testing, bias and accuracy evaluation, human oversight, documentation and a process for correction or appeal. Automated decisions affecting employment, credit, healthcare or access to services deserve particularly careful legal and ethical review.

10. Industry and Regulatory Context

Requirements depend on location and sector. Examples include the European Union General Data Protection Regulation, the United Kingdom data-protection regime, South Africa’s Protection of Personal Information Act, the California Consumer Privacy Act and sectoral rules such as HIPAA in the United States. Payment-card environments are also governed by the Payment Card Industry Data Security Standard, which is an industry standard rather than a general privacy law.

Professionals should never assume that one law applies universally. They should establish:

  • where the organisation operates;
  • where data subjects are located;
  • what categories of data are processed;
  • whether the organisation is controller, processor or both;
  • which sectoral rules and contracts apply;
  • whether cross-border transfers require safeguards;
  • what notification deadlines and rights procedures apply.

Supplier contracts should define permitted processing, confidentiality, security measures, subcontracting, assistance with rights requests, incident notification, deletion or return of data and audit or assurance rights. Cloud outsourcing does not transfer away the organisation’s accountability.

11. Applied Case: University Learning Analytics

The following is an illustrative case.

Background

A university proposes a learning-analytics platform that combines attendance, library use, learning-management-system activity and assessment results. It intends to identify students who may fail and automatically send intervention alerts to academic advisers.

Problem

The proposal includes precise timestamps, device identifiers and detailed behavioural histories. Students have not been clearly informed, and the project team assumes that enrolment consent permits all future analytics. Advisers want to retain data permanently to support longitudinal research.

Analysis

The university must define the purpose: immediate student support, institutional research or both. These purposes may require different legal bases, notices, retention periods and access rules. It should assess whether all fields are necessary and whether a less intrusive risk indicator can replace raw browsing histories. Device identifiers may be unnecessary for intervention.

The system may produce false positives or systematically flag students with limited connectivity, disabilities or caring responsibilities. An automated alert should therefore support human review, not determine academic sanctions. Access should be limited to authorised advisers, and students should have a route to correct inaccurate records or challenge an explanation.

Approach and solution

The university conducts a privacy impact assessment, consults students and staff, documents purposes and publishes a clear notice. It separates identifying information from analytical features, uses pseudonymous identifiers for research, applies role-based access, encrypts data, logs access and sets a defined retention schedule. Raw activity data is deleted after the intervention period unless a documented legal or research justification exists. Model performance is tested across relevant student groups, and advisers receive training on responsible interpretation.

Outcome

The project proceeds with reduced data collection, transparent communication and human oversight. The university can demonstrate accountability and is less exposed to surveillance, discrimination and breach risks. The intervention programme is evaluated using educational outcomes rather than the volume of monitoring data collected.

Learning points

The case shows that privacy is a design and governance issue. Consent is not automatically transferable between purposes; minimisation and retention must be explicit; algorithmic results require human judgement; and security controls must be combined with fairness and transparency.

12. Implementation Guidance for Organisations

A practical privacy and governance programme can follow these steps:

  1. Inventory data: identify systems, owners, categories, flows, suppliers and locations.
  2. Classify information: distinguish public, internal, confidential, sensitive and regulated data.
  3. Map purposes and obligations: document why each category is processed and which rules apply.
  4. Assess risk: consider unauthorised access, misuse, discrimination, loss, surveillance and inability to exercise rights.
  5. Select controls: implement least privilege, encryption, secure development, logging, retention automation and supplier controls.
  6. Document decisions: maintain policies, records of processing, impact assessments and exceptions.
  7. Test effectiveness: perform access reviews, vulnerability assessments, rights-request exercises, deletion tests and incident simulations.
  8. Train personnel: use role-specific instruction for developers, administrators, managers and ordinary users.
  9. Measure and improve: track overdue access reviews, unresolved rights requests, deletion failures, incidents and audit findings.

Useful indicators must be interpreted carefully. A high number of blocked attacks may reflect good detection, increased attack volume or changes in configuration; it is not by itself proof of security. Similarly, zero reported privacy complaints may indicate under-reporting rather than perfect compliance.

Challenges and Limitations

Privacy programmes face practical constraints. Data may be duplicated across legacy systems, making deletion and access requests difficult. Laws may conflict with operational practices or differ across countries. Small organisations may lack specialist staff. Excessive compliance documentation can become a checkbox exercise, while excessive monitoring can undermine trust and create new risks.

There is also no perfect anonymisation guarantee for rich datasets. Combining supposedly anonymous records with public or third-party information may enable re-identification. Encryption protects data from many threats but does not prevent misuse by an authorised user or make unlawful processing lawful. Frameworks provide structure, but they cannot decide every ethical question. Professional judgement, consultation and ongoing review remain necessary.

Chapter Summary

Privacy concerns the justified and fair handling of information about people, whereas security protects information and systems against unauthorised or harmful actions. Ethical practice extends beyond minimum legal compliance by considering dignity, proportionality, fairness and harm.

Core privacy principles include lawfulness, transparency, purpose limitation, minimisation, accuracy, storage limitation, integrity, confidentiality and accountability. Consent must be informed, specific, freely given and withdrawable, but it is only one possible basis for processing. Data-subject rights require searchable systems, controlled workflows and evidence of action. Retention schedules, legal holds and secure disposal are essential parts of database governance.

Breach management requires detection, containment, assessment, notification decisions, remediation and lessons learned. ISO/IEC 27001, NIST CSF and CIS Controls provide complementary structures for risk management and operational safeguards, but they do not replace applicable laws. Ethical monitoring and AI use require necessity, proportionality, transparency, human oversight and mechanisms for correction. Effective governance assigns accountability across leadership, data owners, technical teams, legal advisers, auditors and users.

Key Terms

Privacy: Appropriate control over information relating to people.

Personal data: Information relating to an identified or identifiable person.

Information security: Protection of information and systems from unauthorised or harmful actions.

Data subject: Person to whom personal data relates.

Controller: Organisation determining the purposes and means of processing.

Processor: Organisation processing data on behalf of a controller.

Processing: Any operation performed on personal data.

Consent: Freely given, specific and informed agreement to processing.

Purpose limitation: Restriction of data use to specified and compatible purposes.

Data minimisation: Collection and use of only data necessary for a purpose.

Pseudonymisation: Replacing identifiers while retaining a means of re-identification.

Anonymisation: Transformation intended to prevent reasonable identification.

Retention schedule: Documented rules for keeping and disposing of records.

Legal hold: Suspension of normal deletion due to anticipated or active legal matters.

Personal-data breach: Unauthorised access, disclosure, alteration, loss or destruction of personal data.

Privacy impact assessment: Structured evaluation of privacy risks and mitigating controls.

Accountability: Ability to demonstrate compliance and responsible decision-making.

Least privilege: Limiting access to what a user or process requires.

Governance: Direction, oversight, accountability and decision-making for an organisation.

Review Questions

Short Answer Questions

  1. Distinguish privacy from information security.
  2. What is purpose limitation, and why is it important?
  3. State four characteristics of valid consent.
  4. Why is pseudonymised data often still personal data?
  5. Name three stages in a personal-data breach response.

Long Answer Questions

  1. Explain the principal privacy principles and show how they influence database design.
  2. Discuss the relationship between retention schedules, legal holds and secure disposal.
  3. Compare the roles of ISO/IEC 27001, the NIST Cybersecurity Framework and CIS Controls.
  4. Explain how an organisation should manage a data-subject access request.
  5. Discuss the ethical and legal risks of employee monitoring and propose safeguards.

Analytical / Application Questions

  1. A retailer wants to use loyalty-program data collected for discounts to assess customer creditworthiness. Analyse the purpose-limitation, transparency, fairness and governance issues, and recommend a defensible approach.
  2. A cloud storage bucket containing customer identity documents is accidentally exposed for six hours. Develop an incident-response and notification decision process.
  3. A hospital plans to deploy an AI model that predicts readmission risk. Design a privacy-by-design and responsible-AI review covering data minimisation, access, accuracy, bias, human oversight, retention and patient rights.

Multiple Choice Questions with Answers

Question 1

Which principle requires an organisation to collect only information necessary for a defined purpose?

A. Data minimisation

B. Availability

C. Non-repudiation

D. Open access

Correct Answer: A. Data minimisation

Question 2

Which statement best describes valid consent?

A. It is always implied by using a website.

B. It is freely given, specific, informed and withdrawable.

C. It is valid only when stored as a Boolean value.

D. It cannot be withdrawn after collection.

Correct Answer: B. It is freely given, specific, informed and withdrawable.

Question 3

What is the main difference between pseudonymisation and anonymisation?

A. Pseudonymisation always makes data public.

B. Anonymisation requires stronger passwords.

C. Pseudonymised data may still be linked to a person using additional information.

D. There is no difference.

Correct Answer: C. Pseudonymised data may still be linked to a person using additional information.

Question 4

Which activity most directly supports storage limitation?

A. Creating an indefinite backup archive

B. Publishing all database fields

C. Removing all access logs immediately

D. Defining and enforcing a documented retention schedule

Correct Answer: D. Defining and enforcing a documented retention schedule

Question 5

Which NIST Cybersecurity Framework function includes organisational context, roles and oversight?

A. Govern

B. Detect

C. Respond

D. Recover

Correct Answer: A. Govern

Question 6

An organisation receives a request to correct inaccurate customer information. Which data-subject right is being exercised?

A. Portability

B. Rectification

C. Restriction

D. Objection to marketing

Correct Answer: B. Rectification

Question 7

Which action is most appropriate when an automated student-risk score may be inaccurate?

A. Use it as an automatic basis for expulsion.

B. Delete all audit records.

C. Require human review and provide a correction or challenge process.

D. Publish the score publicly.

Correct Answer: C. Require human review and provide a correction or challenge process.

Question 8

Which statement about security frameworks and law is most accurate?

A. Implementing a framework automatically satisfies every privacy law.

B. Frameworks are irrelevant to compliance.

C. Only encryption is required for compliance.

D. Frameworks support control implementation but do not replace applicable legal requirements.

Correct Answer: D. Frameworks support control implementation but do not replace applicable legal requirements.

Question 9

What should generally happen first after detecting a suspected personal-data breach?

A. Contain the exposure while preserving evidence.

B. Delete all affected records without investigation.

C. Publicly blame an employee.

D. Disable every organisational system permanently.

Correct Answer: A. Contain the exposure while preserving evidence.

Question 10

Why is monitoring employee keystrokes ethically questionable?

A. It can never generate any security value.

B. It may be disproportionate, intrusive and unrelated to the legitimate security purpose.

C. It automatically anonymises employee data.

D. It eliminates the need for access controls.

Correct Answer: B. It may be disproportionate, intrusive and unrelated to the legitimate security purpose.

Database & Information Security
Chapter 13 of 15