- Identify privileged accounts across application, database and operating system layers
- Test controls that restrict and monitor privileged activity
- Evaluate segregation of duties conflicts using a conflict matrix
- Assess mitigating controls when conflicts cannot be removed
Why privileged access gets its own lesson
AS 2110.B4 names the possibility of IT personnel gaining access privileges beyond those necessary to perform their assigned duties, thereby breaking down segregation of duties, as a specific risk from IT. Privileged users can create users, change configurations, alter data outside normal workflows, and sometimes delete the logs that would show what they did. One unmonitored administrator account can undermine every other access control.
Where privileged access lives
| Layer | Examples of privileged rights |
|---|---|
| Application | System administrator role, security administrator, ability to change posting periods or approval limits |
| Database | Direct read and write access to ledger tables |
| Operating system | Root or administrator accounts on servers hosting the application or database |
| Directory and network | Domain administrator rights that can create any user or reset any password |
| Generic and service accounts | Shared vendor support logins, accounts used by interfaces |
Ask for the listing at each layer for each in-scope application. Generic accounts deserve attention: if five people know the password to a shared administrator account, you cannot attribute activity to any one of them.
Testing privileged access controls
Common key controls and how to test them:
- Restriction. Privileged rights are limited to people whose jobs require them. Obtain the privileged user list, validate its completeness, and inquire and inspect job descriptions for each user. Finance users with administrator rights are a red flag.
- Approval. New privileged access is approved by a designated owner. Test as for provisioning.
- Monitoring. Privileged activity is logged and reviewed by someone independent of the privileged users. Test a sample of reviews: was the log complete, was the reviewer independent, were unusual items investigated?
- Vendor and emergency access. Accounts used by vendors or for emergencies are enabled only on request and disabled after use. Inspect enable and disable dates against requests.
Segregation of duties in systems
Segregation of duties (SoD) prevents one person from both initiating and approving, or recording and safeguarding. In systems, SoD is enforced by roles and permissions. A conflict exists when one user holds two permissions that together allow an error or fraud to go undetected, for example:
- create a vendor and approve payments to vendors;
- post a manual journal entry and approve it;
- change customer credit limits and release orders on credit hold;
- develop code and move it into production.
Using a conflict matrix
A conflict matrix lists the sensitive permissions on both axes and marks which pairs conflict. The audit approach:
- Agree the conflict rules with management (they own the control).
- Extract users and permissions from the system and test the extract.
- Run the rules against the extract to list users with conflicts.
- For each conflict, determine whether it is removed, accepted with a mitigating control, or unresolved.
A segregation of duties conflict matrix gives a starting layout.
Mitigating controls
Small finance teams cannot always separate duties. A conflict can be accepted when a mitigating control is designed to catch the risk the conflict creates and is precise enough. For a controller who can both post and approve entries, a mitigating control might be a monthly review by the CFO of all entries posted by the controller, using a complete system report. Test the mitigating control directly, including the completeness of the report it uses. A general statement that "the CFO reviews the financial statements" is not precise enough.
Linking to the financial statement risk
For each unresolved conflict, ask what misstatement could result and whether anything happened. Run the transactions the conflicted user both initiated and approved during the period. If none exist, the risk did not crystallize, but the deficiency remains and is evaluated on what could have happened.
Administrator rights at Cobalt Ridge Engineering
Cobalt Ridge Engineering's general ledger system has six users with the system administrator role: two IT staff, the controller, the assistant controller, and two generic vendor support accounts.
The team tests restriction and finds the controller and assistant controller hold administrator rights so they can reopen closed periods. The two vendor accounts are always enabled.
The team then examines activity logs. During the year, the controller reopened the September period twice and posted four entries totaling $186,000 after the period had been reported to the lender. Each entry had supporting documentation and appeared on a system report of entries posted after period close, which the CFO reviews and signs each month. The team inspects the signed reports.
For the vendor accounts, the logs show eleven logins, all on dates matching vendor support tickets, with no posting activity.
Evaluation: two deficiencies. First, finance users hold administrator rights, a segregation of duties conflict between posting entries and controlling periods. The mitigating control (the CFO's monthly review of the post-close entry report) exists, and the team tests that report for completeness and accuracy. Second, always-enabled vendor accounts are a design deficiency in privileged access. No unauthorized activity was found.
Conclusion: both deficiencies are communicated to management. The team relies on the tested mitigating control for journal entries and does not extend substantive work beyond its journal entry testing.
Self-check
Answer each question before you open the answer.
Why are generic administrator accounts a problem even if no misuse is found?
Show answer
Activity on a shared account cannot be traced to an individual, so monitoring cannot hold anyone accountable and the log review loses its value as a control.
What makes a mitigating control effective for a segregation of duties conflict?
Show answer
It is designed to detect the specific risk the conflict creates, operates at a level of precision that would catch a material misstatement, and uses complete and accurate information. It must be tested, not assumed.
Who should own the conflict rules in a conflict matrix?
Show answer
Management, because the segregation of duties design is management’s control. The auditor evaluates and tests it.
Use it on the file
- GuideSegregation of Duties: How to Design and Test a Conflict Matrix
- TemplatePrivileged Access Review Checklist
- TemplateSegregation of Duties Conflict Matrix
Sources
- PCAOB, Auditing Standards compilation including AS 1105, AS 2110, AS 2201, AS 2601 and AS 2605
- AICPA, Statements on Auditing Standards currently effective (AU-C sections, including AU-C 315 as amended by SAS No. 145)
Standards are paraphrased from the primary sources listed above; read the source before relying on a requirement. This lesson is training material, not professional advice. Report an error