How to approach it
Begin with verbs and resources. An analyst who views monthly reports needs read access to those reports. Publishing reports, editing raw data, and changing access permissions are separate abilities.
Use short-lived elevation for an occasional administrative task when the workflow supports it. Give each service its own identity so access can be audited and revoked independently.
Worked example
A daily export job reads invoice totals and writes a report to a single folder. Give its service identity read access to the required totals and write access to that folder. The job does not need access to payment details or permission to change the permissions of either location.
Practice questions
A contractor needs to read one project’s files for five days. What access should you select?
Show answer and explanation
Project-scoped read access with an expiration after five days.
A batch job needs to append rows to one table. It currently uses the database owner account. What would you change?
Show answer and explanation
Use a dedicated identity with the insert permissions required on that table and remove owner access from the job.
A staff member reads reports but sometimes approves them while covering a colleague. How should approval access be handled?
Show answer and explanation
Make approval a separate permission and grant it temporarily through the normal approval process when coverage is needed.
Official reference
CompTIA Security+ certification and objectives
What to study next
- Security+ practice: Incident triage
Triage uses available evidence and business impact to set priority and choose the next safe response.