The Field GuideBusiness Systems

Data ownership, permissions and audit trails

How to turn vague data governance into named accountability, minimum access and records that can explain what changed.

By Adi Huric, founder of Most AI LabsAugust 20269 min read

On this page
    Data ownership is accountability, not possessionPermissions should follow least privilegeAn audit trail should answer a real questionBritish Columbia privacy duties shape the designBuild a small governance packTest the controlsSource checkSources

Security conversations often begin with tools. The more useful starting point is responsibility.

Who is accountable for customer identity data? Who may export it? Who approves a change to payment details? Who can determine what happened after an error?

Data ownership, permissions and audit trails answer different parts of the same question: who may do what to which information, and how can the organization prove it?

Data ownership is accountability, not possession

A data owner is the business role accountable for a dataset's purpose, quality, access, retention and appropriate use. The owner may delegate daily administration to a data steward or system administrator.

For example, a sales leader might own opportunity data, finance might own invoices, and a privacy officer might set controls that apply across both. "IT owns all data" is rarely workable because IT cannot decide the business meaning or lawful need for every field.

Microsoft's data-governance guidance recommends defining ownership early and assigning roles for quality, access and life-cycle responsibilities. Microsoft

Permissions should follow least privilege

Give a person or service only the access required for its current function. Separate abilities to view, create, edit, approve, export, delete and administer.

A role called "manager" is too vague if every manager can export every customer. Build a permission matrix:

RoleViewChangeApproveExportDelete
Sales representativeAssigned accountsContact and activity fieldsNoNoNo
Sales managerTeam accountsOpportunity fieldsDiscounts within limitTeam reportNo
FinanceCustomer billing recordsInvoice fieldsCreditsFinance reportRestricted
System administratorSystem metadataConfigurationNo business approvalLogged emergency useRestricted

NIST defines least privilege as allowing only the minimum access necessary for assigned tasks. Its security controls also address separation of duties, event logging and review. NIST SP 800-171 Rev. 3

Review access when someone changes role and remove it promptly when they leave. Service accounts need owners and expiry or rotation rules too.

An audit trail should answer a real question

For important changes, record:

  • actor, including a service or impersonating administrator;
  • event and affected record;
  • date and time with an unambiguous timezone;
  • previous and new value where appropriate;
  • source system and request identifier;
  • reason or approval reference for sensitive operations;
  • success, failure and relevant context.

Protect logs from ordinary editing and restrict who can read them. Logs can contain sensitive information, so indiscriminate logging creates a second privacy problem. Do not record passwords, secrets or full payment credentials.

An audit trail is not the same as a backup. A log explains events. A backup helps restore state. A record of who deleted a file does not recover it.

British Columbia privacy duties shape the design

Most private-sector organizations in British Columbia are governed by BC's Personal Information Protection Act, while PIPEDA can also apply in circumstances including interprovincial and international commercial activity. Obtain legal advice for the organization's exact coverage.

BC PIPA makes the organization responsible for personal information under its control and requires a designated person or persons for compliance (section 4). It also requires reasonable security arrangements (section 34), reasonable efforts toward accuracy when information is used to make a decision affecting an individual (section 33), and retention rules connected to decisions and legal or business purposes (section 35). BC Laws

Those duties support practical system requirements: named accountability, constrained access, correction workflows, documented retention and secure destruction.

Build a small governance pack

For each material dataset, keep:

  1. business owner and operational steward;
  2. purpose and lawful authority or consent basis;
  3. fields, classification and source;
  4. authoritative system and integrations;
  5. role-based permission matrix;
  6. retention and deletion rule;
  7. audit events and review cadence;
  8. incident and correction procedure;
  9. vendors, locations and contractual controls.

Update it when the workflow or system changes. A privacy impact assessment can expose risks before implementation; the Office of the Information and Privacy Commissioner for BC publishes PIA guidance for organizations. OIPC BC

Test the controls

Do not stop at a policy. Try to export data as a low-privilege user. Disable an employee and verify downstream access. Change a sensitive value and reconstruct the event. Restore a sample backup. Confirm expired records actually leave all intended systems.

Governance becomes credible when an organization can demonstrate the control, not merely point to a paragraph saying the control exists.

Source check

This is operational guidance, not legal advice. BC PIPA and PIPEDA applicability depends on the organization and activity. Verify current law, contracts and regulator guidance before implementation.

Sources