Data Access Permission Audit Matrix Builder
Create a data access audit matrix that maps datasets, roles, owners, PII risk, permission levels, least-privilege gaps, and remediation actions.
Prompt Template
You are a data governance analyst. Build a practical access permission audit matrix for our datasets, dashboards, and analytics tools. **Organization/team:** [company/team context] **Systems in scope:** [warehouse, BI tool, CRM, product analytics, spreadsheets] **Known roles/groups:** [analyst, finance, support, sales, executives, contractors] **Data types:** [PII, financial, health, product usage, customer content, internal metrics] **Current access data:** [paste exports, group lists, role names, or describe] **Compliance requirements:** [GDPR, SOC 2, HIPAA, ISO 27001, internal policy] **Business constraints:** [teams that need broad access, audit deadline, tool limitations] Create: 1. **Access matrix** — systems/datasets vs roles/groups/users 2. **Sensitivity classification** — public/internal/confidential/restricted with rationale 3. **Least-privilege gap analysis** — over-permissioned groups, stale users, risky shared accounts 4. **Risk scoring** — likelihood, impact, priority, evidence needed 5. **Remediation plan** — quick wins, owner, due date, approval path 6. **Exception register** — where broad access is justified and when to re-review 7. **Audit questions** — what to ask system owners before making changes 8. **Ongoing review cadence** — monthly/quarterly controls and access request workflow Assume incomplete data. Mark assumptions clearly and avoid recommending changes that would break critical business workflows without owner approval.
Example Output
Access Permission Audit Matrix
| System/Dataset | Data Sensitivity | Current Access | Needed Access | Gap | Risk | Owner | Action |
|---|---|---|---|---|---|---|---|
| warehouse.customer_pii | Restricted | all_analysts, support_ops, contractors | data_eng, support_leads only | Contractors over-permissioned | High | Data Eng | Remove contractor group after ticket review |
| BI Revenue Dashboard | Confidential | finance, execs, sales_managers | same | None | Low | Finance | Reconfirm quarterly |
| Product Events Raw | Internal + possible PII | analytics, product, interns | analytics, product leads | Intern access too broad | Medium | Analytics | Create masked view |
Quick Wins
1. Disable 8 inactive users from BI tool before Friday.
2. Replace shared "analytics-admin" login with named accounts.
3. Create masked customer table for product managers.
Exception Register
Support leads retain read access to billing status for escalation handling. Review every quarter with Support Ops and Finance.
Tips for Best Results
- 💡Export actual user/group lists from your tools when possible; vague role names create vague audits.
- 💡Classify data before debating access — sensitivity drives the decision.
- 💡Do not remove access blindly; identify business owners and safe rollout steps first.
- 💡Use the exception register to avoid recurring debates about justified broad access.
Frequently Asked Questions
What is the Data Access Permission Audit Matrix Builder prompt?
Create a data access audit matrix that maps datasets, roles, owners, PII risk, permission levels, least-privilege gaps, and remediation actions. It's a free ChatGPT prompt template from our Data Analysis collection — copy it, fill in the bracketed variables, and paste it into your AI tool.
Which AI tools work with this prompt?
It's written and tested for ChatGPT, Claude and Gemini. Any AI assistant that accepts free-form text prompts will handle it well.
How do I customize this ChatGPT prompt?
Replace the bracketed variables — such as [company/team context] — with your own details before running it. Export actual user/group lists from your tools when possible; vague role names create vague audits.
Is this prompt free to use?
Yes. Every prompt on PromptAtlas is free to copy, customize, and use — no signup required.
Related Prompts
Transit Fare Evasion Pattern Analysis Builder
Analyze transit fare evasion patterns with station segments, time trends, inspection data, equity safeguards, revenue estimates, and intervention testing.
Food Pantry Distribution Demand Analysis Builder
Analyze food pantry demand, visit patterns, household needs, item stockouts, volunteer coverage, and distribution-slot capacity for nonprofit food programs.
Library Hold Queue Wait Time Analysis Builder
Analyze public library hold queues, copy availability, branch demand, wait times, and purchasing signals for print, ebook, audiobook, or media collections.
Sterile Processing Instrument Tray Turnaround Analysis Builder
Analyze sterile processing instrument tray turnaround times, bottlenecks, rework, case readiness, staffing, and quality issues for hospital operations.
Clinical Lab Specimen Turnaround Time Analysis Builder
Analyze clinical lab specimen turnaround time by collection, transport, accessioning, testing, verification, priority, department, and bottleneck risk.
Municipal Permit Processing Backlog Analysis Builder
Analyze building permit intake, review stages, resubmissions, staffing, and service targets to find bottlenecks and reduce municipal permit backlogs.