Course contents
Practitioner · Course 5: Data Governance and When to Move Beyond Spreadsheets · Lesson 1 of 5

Setting data responsibilities, access rights and change control across a business

Level: PractitionerTime: 45 minutesOrder used: A (the T-shirt)Tool: Data governance decision tool
For anyone who sets up or works inside a shared order record and needs to know who should be able to view, enter, or change each part of it. The case uses Order A and only approved master figures.
BuyerNorthline Apparel
FactoryDelta Garments
OrderA — 15,000 T-shirts
FabricSingle jersey, 180 GSM, Ne 30/1
Agreed FOBUSD 3.20 per piece
Total order valueUSD 48,000
02Opening

This page teaches who should be able to view, enter or change each part of a shared order record, and how a change to it should be controlled

An export order record holds commercial facts, technical specifications, planning numbers and status updates that several people touch every week. Without a clear rule for who may view a field and who may change it, anyone with access to the file can edit a price, a quantity or a specification, whether or not that change has been approved. A wrong edit made in good faith can travel just as far as one made by mistake.

This lesson gives you a working method for setting data responsibility, access rights and change control on a shared order record, so the people who need to see information can see it, the people who may change it are named, and every change follows an approved path before it takes effect. Without this, the file itself becomes the least controlled part of the order, even when every department around it is well run.

03Before you start

What you need, and what this lesson does not cover

You need: a basic understanding of an order record, a purchase order and the main factory departments. Track 17, Course 1 on data ownership is useful preparation.

By the end of this lesson you can:

  • explain the difference between data ownership and access rights in plain words;
  • assign a permission level to a role for a specific part of an order record;
  • separate a field that a role may only view from a field that role may change;
  • describe what a change-control step must record before a change takes effect;
  • recognise when a shared file's access setup has become too loose to trust.

Not covered here: software configuration, database administration, or a specific ERP or PLM product. Lesson 5.2 covers the audit trail that proves who changed what and when; this lesson stays vendor-neutral and focuses on the business rule first.

04Key terms

Words you will meet in this lesson

TermMeaning
Data ownerThe role accountable for confirming that a specific business data item is current and correct.
Access rightPermission that allows a specific role to view, enter or change a specific piece of business information.
Permission levelThe specific set of actions, such as view, enter, or approve, a role is allowed to perform on a record.
Change controlThe agreed process for approving, recording and communicating a change to controlled business information before it takes effect.
Version historyThe ordered record of every saved version of a file or record, showing what changed and when.
05Teaching
The rule

Every shared order record needs a named data owner for each part, an access right set for every role and an approval step before a controlled field can change

A shared order record is not one block of information; it is several groups of fields, each created or approved by a different part of the business. Commercial fields such as price and quantity, technical fields such as specification and construction, and status fields such as production or shipment progress each need their own accountable owner. Once an owner is named, that owner decides which roles may only view the field and which roles may change it, and every change to a controlled field passes through an approval step before it takes effect.

Without this structure, access tends to default to "everyone can edit everything," because that is the easiest setting to leave in place. That default feels convenient until the day someone changes a field they were never meant to control.

Data ownerNames who may viewand who may changeAccess rights by roleView-only or view-and-changefor each field groupApproval stepEvery change to acontrolled field is checked
An access right is not the same as data ownership. The owner decides who gets which right; the right itself only takes effect once someone applies it in the shared file or system.
What you meet in real life

Who needs to view a field, and who needs to change it, differs by field group and by business model

What can differThe shapes you will meetWhy it matters to you
Export order under Make to OrderAn export buyer's confirmed price and quantity are set once per order and rarely change after confirmation; access to change them is usually kept very narrow.A narrow change list makes an unapproved edit easier to notice and easier to trace back to one person.
Domestic replenishment under Make to StockA domestic brand's own standing forecast is updated on a routine cycle by a small planning team, not by every person who reads it.Frequent, routine updates need a clear owner just as much as a rare one does, or the file drifts quietly over many small edits.
Hybrid order handled through an agentAn agent working on a hybrid mix of order types for more than one buyer often needs to view several buyers' records but should not hold change rights on any buyer's confirmed commercial fields.Wide visibility across buyers is common in this role; wide change rights across buyers is a real risk if the agent's own access is not kept narrower than its visibility.
Production and quality status fieldsProduction reports what has been made; quality records inspection results. Each department should hold change rights only on the status field its own work creates.A field changed by someone outside the department that created the fact can no longer be trusted as that department's own record.
Different product familiesSocks add gauge and reinforcement fields; knit-to-garment adds yarn count and shaping; terry adds pile-height and border fields; bedding adds set-component fields.The fields change by product family, but every field still needs one named owner and a defined access right.
The case we follow

Mona sets access rights on Order A's shared record before Delta Garments' new sewing line starts work

Northline Apparel has confirmed Order A with Delta Garments: 15,000 T-shirts, single jersey 180 GSM, Ne 30/1, agreed FOB USD 3.20 per piece, total order value USD 48,000. Mona, the factory merchandiser, is setting up the shared order record before the sewing line begins work under it.

Mona does not give every person who touches the order full edit access to every field. She groups the record's fields by owner: the confirmed price and quantity, owned by merchandising against the approved purchase order; the approved specification, owned by the technical team; the production-output field, owned by the sewing line supervisor; the inspection-result field, owned by quality. For each group, she names which roles may only view it and which single role may change it, and she sets the shared file so that a change to price or quantity requires her own approval before it is saved as current.

Karim, the production manager, can view the confirmed quantity and the approved specification at any time, because his team needs both to plan the line. He cannot change either field, because neither fact is created by production.

The worked number

An unapproved price edit on Order A shows what a missing change-control step can cost before anyone notices

Suppose a data-entry error changes Order A's recorded FOB from the agreed USD 3.20 to USD 3.10 per piece in the shared file, and the wrong figure is used in an internal costing check before anyone catches it.

Confirmed FOB: USD 3.20 per piece
Wrongly entered FOB: USD 3.10 per piece
Difference per piece: 3.20 − 3.10 = USD 0.10
Value affected on 15,000 pieces: 15,000 × 0.10 = USD 1,500

USD 1,500 is a real distortion against Order A's own fixed profit of USD 0.26 per piece, or USD 3,900 total profit on the order (15,000 × 0.26). A change-control step that required approval before the price field could be saved would have caught the wrong entry before it reached a costing check, at no cost beyond the few minutes the approval step takes.

GOOD: controlled accessPrice field is view-only for most rolesA change request needs merchandising's approvalWrong entry is caught before useBAD: open accessAny user can overwrite the price fieldNo approval step existsUSD 1,500 distortion reaches costing
A change-control step is cheap compared with the cost of an uncaught wrong figure. The saving is not in avoiding every mistake, but in catching a mistake before it is used.
The method

Set data responsibility, access rights and change control in five steps

  1. Group the order record's fields by who creates or approves the fact behind them: commercial, technical, planning, production, quality, logistics.
  2. Name one accountable owner for each field group.
  3. Assign a permission level to every role that touches the record: view-only, or view-and-change, for each field group, never "full access" by default.
  4. Require an approval step before a controlled field can be saved with a new value, naming who must approve it.
  5. Review the access list on a fixed schedule, removing rights that no longer match a person's current role.
The trap

A common mistake is giving every team member full edit access to save setup time when the order starts

That choice feels efficient in the first busy week of an order, because nobody has to ask anyone else for a right they might need later. It becomes expensive the first time an unapproved change reaches a costing sheet, a production plan or a shipment document before anyone checks it, because there is no way to see who made the change or to have stopped it before it was saved.

The better rule is simple: give the narrowest access right that lets a role do its own job, and add a change-control step to every field whose wrong value would cost money or time to correct.

06In plain words

Think of a shared order record as a filing cabinet with several drawers. One drawer holds the price and quantity the buyer confirmed. Another holds the approved product specification. Another holds what production and quality have actually done. Not everyone who can open the cabinet should be able to write in every drawer, and writing in the price drawer should need someone's sign-off before the new figure is filed.

Set an owner for each drawer, decide who may only look and who may write, and require approval before a write to an important drawer is saved. When you do that, a mistaken or unapproved change is caught before it can travel through the rest of the order.

07Quick check
  • Data ownership names who is accountable for a fact; an access right controls who may view or change it in the shared record.
  • A permission level should be the narrowest one that still lets a role do its own job.
  • View-only access is normal and useful; it is not a lesser form of trust.
  • A controlled field, such as price or quantity, needs an approval step before a change is saved.
  • Access rights should be reviewed on a schedule, not left as they were set on day one.
  • The same rule applies across product families; only the field groups change.
08Workplace scenario

A newly added planning assistant tries to correct Order A's quantity field directly in the shared file after a phone call with the buyer

A planning assistant, added to Delta Garments' team this week, takes a phone call from someone at Northline Apparel who mentions a possible quantity change for Order A. Before Mona sees the call notes, the assistant opens the shared order file and edits the confirmed quantity field directly, intending to save time.

  • The assistant's role is set to view-only on the commercial field group, but the shared file currently has no lock preventing a save.
  • No written confirmation of the new quantity exists yet from Northline Apparel.
  • Fabric has already been requested from stock based on the current confirmed quantity of 15,000 pieces.

Should the assistant's edit be accepted as the new confirmed quantity? Decide before opening the answer.

Show decision

No. The edit is not accepted; the field is restored to 15,000 pieces until a written, approved change is received.

1. The commercial field group's approval step requires a written confirmation or amendment from Northline Apparel, not a verbal mention during a phone call, before the confirmed quantity can change. 2. The assistant's permission level is view-only on this field group. A gap in the file's own lock setting let the save happen, but the assistant was never the accountable role for this field. 3. Fabric already requested against 15,000 pieces would be wrong if the unconfirmed number had been accepted, so restoring the approved value avoids a second, larger correction later.

The cost of accepting the unapproved edit is not only the risk of a wrong fabric request; it is that the shared record would show a number nobody can actually prove, which is worse than showing the last approved number while the real change is confirmed in writing.

09What it costs

A missing access control turns one convenient shortcut into a cost that lands somewhere else in the order

Order A's fixed total order value is directly derived from its quantity and agreed price:

15,000 pieces × USD 3.20 per piece = USD 48,000 total FOB value

An unapproved change to a controlled field rarely destroys the whole order value at once. Its real cost is smaller and easier to miss: a wrong fabric quantity requested, a costing sheet built on a wrong price, or a production plan built on an unconfirmed quantity. Each of these can cost hours of rework or a real cash difference, such as the USD 1,500 shown earlier against Order A's own fixed figures, well before anyone notices the original access gap that let it happen.

The cheapest point to prevent that cost is the access setting itself: a narrow permission level and a required approval step, set once, before the order's shared record is opened to the wider team.

10Working template

Data governance decision tool: record field groups, owners, access rights and change-control steps

Use the T17-C05 Data governance decision tool workbook. In the Access and responsibility sheet, list each field group in the shared order record, its accountable owner, the roles that may view it, the roles that may change it, and whether a change to it needs approval. Start with Order A's own field groups, then repeat the exercise for a shared record you use at work.

[Download the Data governance decision tool workbook](../../templates/T17-C05-data-governance-decision-tool.xlsx)

Download the Data governance decision tool (Excel)

11Check yourself

1. Why does Mona give Karim view-only access to Order A's confirmed quantity and approved specification instead of full edit access?

2. Order B (3,000 jeans, agreed target FOB USD 9.80 per piece) is entered in a shared file with a data-entry error of USD 9.70. Before anyone corrects it, the wrong figure is used once in an internal costing check. What is the value affected on the whole order?

12Glossary
ENARFRTRMeaning
Data ownerمسؤول البياناتResponsable de la donnéeVeri sorumlusuThe role accountable for confirming that a specific business data item is current and correct.
Access rightحق الوصولDroit d'accèsErişim hakkıPermission that allows a specific role to view, enter or change a specific piece of business information.
Permission levelمستوى الصلاحيةNiveau d'autorisationYetki seviyesiThe specific set of actions, such as view, enter or approve, a role is allowed to perform on a record.
Change controlضبط التغييرContrôle des changementsDeğişiklik kontrolüThe agreed process for approving, recording and communicating a change to controlled business information before it takes effect.
Version historyسجل الإصداراتHistorique des versionsSürüm geçmişiThe ordered record of every saved version of a file or record, showing what changed and when.
13Next

Lesson 5.2: Using permissions and an audit trail to know who changed what and when

Next you will learn how a permission level and an audit trail work together so a buyer and a factory can both trust who changed a shared record, and when. Back to the course map

14Ladder

RecognizeName the field groups in a shared order record and their accountable owners.
ConnectSee how a narrow permission level supports the owner's accountability for a field.
CompareSeparate a role that may view a field from a role that may change it.
DecideChoose whether an edit made without an approval step should be accepted as the new confirmed value.