Privileged access and segregation of duties in IT environments

How to identify and test privileged accounts at the application, database and system layers, and how to evaluate segregation of duties conflicts inside systems.

4 min read · CORAA Team
Lesson 5 of 14 · 0 of 14 complete
In this lesson you will
  • 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:

  1. 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.
  2. Approval. New privileged access is approved by a designated owner. Test as for provisioning.
  3. 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?
  4. 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:

  1. Agree the conflict rules with management (they own the control).
  2. Extract users and permissions from the system and test the extract.
  3. Run the rules against the extract to list users with conflicts.
  4. 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.

Worked example

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.

  1. 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.

  2. 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.

  3. 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.

Sources

Back to the syllabus

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

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required