forumNew topic

We don't have documentation on who can do what in the company, it's a mess every day — how do you create an authority matrix?

AAyşe O***Veteran
Job title
Quality control inspector
Sector
Energy
Organization type
120-person company
Joined
Dec 2023
Message
126
#1

The marketing guy wants access to accounting reports, so I told him 'I don't know, you need to ask the IT manager'. The IT manager asks someone else, there's no system like this. Access needs to be set differently for everyone based on seniority, role, department — but how?

Who needs access to the database? Can there be conditional access ('reporting only', 'read only')? Can the sales team access customer data but delete it? Will IT have full system access? Can managers override?

It looks very complicated to start with, but if there's a template source I can begin. Is listing it in an Excel table enough, or do we need to define roles in the system?

CCem K***Member
Job title
QA Tester
Sector
IT services
Organization type
chain store
Joined
Sep 2023
Message
138
Most Helpful#2

Setting up an Authority Matrix (Access Control Matrix): 1) Define resources (database, file share, app, admin panel), 2) Define roles (CEO, Manager, Employee, Contractor), 3) Create a permission matrix for each role (Create, Read, Update, Delete = CRUD), 4) Conditional access: time-based (9-5), data-based (own customers), approval-based (>X TL transaction approval). Excel Template: Rows = Resources, Columns = Roles, Values = CRUD, Conditions. Automation: Role-Based Access Control (RBAC) in the system (Active Directory, IAM platform). Override: Manager approval + audit log. Documentation: policy document, annual review, access audit (quarterly). Implementation: Phase 1 (IT resources), Phase 2 (data resources), Phase 3 (app resources).

KKaan G***ExpertCommunity member
Joined
Jun 2023
Message
94
#3

if u don't make an authority matrix it'll be chaos. make the table in excel: departments on the left resources on top, CRUD in the middle. ceo has full access sales has their own customers accounting has finance resources. for approved access you need manager approval...

HHakan A***Member
Job title
Software team lead
Sector
Catering
Organization type
20-person company
Joined
Oct 2023
Message
86
#4

RBAC vs. ABAC: RBAC (role-based) = define role, assign permission, ABAC (attribute-based) = condition-based (department, location, time, data sensitivity). Tools: Azure AD (role assignment), AWS IAM (policy), Okta (app-based roles). Matrix template: Role x Resource x Action. Audit: Active Directory reporting, Cloud IAM audit logs. Delegation: manager approves access request, IT implements, auto-revoke after date. Segregation of Duties: conflict check for who gets what authority (finance person cannot approve payment).

AAycan U***MemberCommunity member
Joined
Jul 2023
Message
2
#5

authority matrix is simple start in excel. first column department, next column permissions and cEO = everywhere Sales = customer data read-only Accounting = own reports, IT = all. tbh then set up roles in the system (Active Directory) done is done. you need to do an annual review update if there's a transfer...

HHakan U***MemberCommunity member
Joined
Apr 2024
Message
43
#6

Access Control strategy: 1) Define roles (CEO, Manager Employee, Vendor), 2) Define resources (DB file share, app, cloud) 3) Map role → resource → action (CRUD), 4) Conditional rules (time, data approval), 5) Segregation of Duties (incompatible roles) 6) Audit & review (quarterly), 7) Automation (IAM platform). Compliance: GDPR/KVKK → data access audit PCI-DSS → cardholder access restricted. Least Privilege: minimal access at first need-based request. Documentation: role definitions update log, annual certification.

KKader A***Member
Job title
Project manager
Sector
Machinery manufacturing
Organization type
cooperative
Joined
Jan 2022
Message
228

Doki · KVKK compliance consulting · 2025

#7

authority matrix = WHO CAN DO WHAT matrix 😂 CEO does everything temp contractor does the bare minimum intern does nothing. it's in Excel tied to the company sometimes you just wanna cry...

BBurak G***Member
Job title
Accounting clerk
Sector
Accounting & advisory
Organization type
two-branch business
Joined
Oct 2024
Message
184

Doki · Penetration test · 2026

#8

Timely topic.

KKadir K***Veteran
Job title
Product Manager
Sector
Livestock
Organization type
boutique agency
Joined
Aug 2025
Message
131

Doki · Penetration test · 2024

#9

Correct.

AAycan A***Expert
Job title
Social media manager
Sector
Seafood
Organization type
regional distributor
Joined
May 2023
Message
6
#10

if I understood correctly, you're saying: Forgotten test environments are more often the entry point than live systems.

when making decisions write down the worst-case scenario too, not just the best then btw if I were you Id go this route.

OOya Y***ExpertCommunity member
Joined
Jan 2023
Message
60
#11

Let me clarify the technical side. When we decide without measuring, we always end up in the same place.

Correct me if I'm wrong.

İİsmail Ş***MemberCommunity member
Joined
May 2025
Message
177
#12

I didn't know that.

ZZerrin U***MemberCommunity member
Joined
Oct 2024
Message
3
#13

I feel the same way. When we decide without measuring, we always end up in the same place.

The biggest time-waster for us was not knowing who had the final say. If you post the result here, it will help others too.

HHakan V***Member
Job title
Data Analyst
Organization type
regional distributor
Joined
Apr 2024
Message
104
#14

I'm writing this so you don't make the same mistake. Processes without records never improve, because you don't know what to fix.

That's all, sorry if I went on too long.

MMurat K***Member
Job title
Human Resources Manager
Sector
Freight
Organization type
early-stage startup
Joined
Aug 2025
Message
333

Doki · Brand identity · 2023

#15

im cuurious too.

GGökhan B***MemberCommunity member
Joined
Apr 2025
Message
218
#16

I agree, and I'd like to emphasize that. Hasty decisions become decisions you have to fix six months later.

The biggest time-waster for us was not knowing who had the final say. Correct me if I'm wrong.

TTolga G***Veteran
Job title
Secretary
Sector
Plastic
Organization type
regional distributor
Joined
Jan 2024
Message
138
#17

just a heads-up but an untested backup is not a backup.

RRecep Y***Member
Job title
Data entry clerk
Sector
Jewelry
Organization type
workshop
Joined
May 2025
Message
3
#18

I completely agree. Mistakes made on the creating an authority matrix side are usually reversible but expensive.

NNuri Y***ExpertCommunity member
Joined
Oct 2023
Message
246
#19

If I understood correctly, you're saying: Any unwritten clause becomes a point of disagreement later, as both sides remember it differently.

Proven by experience.

KKoray S***MemberCommunity member
Joined
Jul 2025
Message
286
#20

Thanks a lot, I'll try it today.

Reply