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
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:
| Role | View | Change | Approve | Export | Delete |
|---|---|---|---|---|---|
| Sales representative | Assigned accounts | Contact and activity fields | No | No | No |
| Sales manager | Team accounts | Opportunity fields | Discounts within limit | Team report | No |
| Finance | Customer billing records | Invoice fields | Credits | Finance report | Restricted |
| System administrator | System metadata | Configuration | No business approval | Logged emergency use | Restricted |
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:
- business owner and operational steward;
- purpose and lawful authority or consent basis;
- fields, classification and source;
- authoritative system and integrations;
- role-based permission matrix;
- retention and deletion rule;
- audit events and review cadence;
- incident and correction procedure;
- 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
Where this leads
Next step
See where your own visibility stands.
The 7-day audit turns this research into a picture of your business. Yours to keep, whether you hire us or not.
Read next
Build decisions
Build, buy or integrate: when custom software makes sense
A decision framework for choosing custom software, an off-the-shelf product or an integration without turning preference into strategy.
9 min
What things cost
What custom admin platforms cost
A 2026 planning guide to the cost of internal portals and admin software, including discovery, migration, permissions and ownership after launch.
10 min
Build decisions
What a custom CMS is, and when you do not need one
A plain-language guide to content models, editorial workflows and the point at which a custom CMS becomes unnecessary product development.
8 min