Courseiva
easyMultiple ChoiceObjective-mapped

Applying Least Privilege: Backup User with Execute-Only Access

A system administrator needs to assign permissions to a new employee who will be performing database backups. The employee should only be able to execute the backup command but not read or modify the data. Which access control principle should be applied?

Quick Answer

Least privilege is the correct principle because the scenario describes granting an employee exactly the narrow capability their job requires, the ability to execute a backup command, while deliberately withholding broader permissions like reading or modifying the underlying data that aren't necessary to accomplish that specific task. This is the essence of least privilege: access should be scoped to the minimum set of permissions needed to perform a defined function, not granted more broadly just because it might be convenient or because a single elevated account is easier to set up. In practice, this often means using a purpose-built execution capability, such as running a backup utility with a scoped or read-only snapshot mechanism, rather than granting the employee general read or file-level access that would let them view or alter the actual data being backed up. The security value here is concrete: if that employee's account were ever compromised, or if the employee made a mistake, the damage is limited to what a backup-execution privilege alone could do, rather than extending to full read or write access over sensitive data. This scoped-permission approach is what separates least privilege from simply assigning a role that happens to include backup duties among a wider set of permissions; the goal is always the narrowest access that still lets the job get done. When a question describes assigning only the specific permission needed for one task while explicitly excluding broader access, that's least privilege in action.

⚠ Common exam trap

Candidates often confuse 'least privilege' with 'need to know' because both limit access, but least privilege focuses on the minimum permissions to perform an action (execute a command), while need to know focuses on whether the user requires access to specific data content.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Least privilege

The least privilege principle dictates that a user should be granted only the minimum permissions necessary to perform their job function. In this scenario, the employee needs only the ability to execute the backup command (e.g., using a tool like `pg_dump` or `mysqldump` with a read-only snapshot), not read or modify the underlying data files. Applying least privilege ensures the backup process can run without granting broader SELECT or FILE privileges that would allow data access or alteration.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Need to know

    Why it's wrong here

    Need to know applies to information access, not command execution.

  • Least privilege

    Why this is correct

    Least privilege grants only the permissions required to perform the job.

  • Separation of duties

    Why it's wrong here

    Separation of duties splits critical tasks among multiple people, not relevant here.

  • Defense in depth

    Why it's wrong here

    Defense in depth is a layered security approach, not a permission assignment principle.

About these practice questions

This SSCP question is part of Courseiva's 920-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more way this is tested on SSCP

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. A system administrator needs to implement a control that ensures users can only access files necessary for their job functions. Which principle is being applied?

easy
  • A.Need-to-know
  • B.Separation of duties
  • C.Job rotation
  • D.Least privilege

Why D: The principle of least privilege ensures that users are granted only the permissions necessary to perform their job functions, minimizing the attack surface and potential damage from accidental or malicious actions. In this scenario, restricting file access to only what is needed for job duties directly implements least privilege, as it limits access rights to the minimum required. This is distinct from need-to-know, which focuses on information disclosure rather than access permissions.

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This SSCP practice question is part of Courseiva's free ISC2 certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SSCP exam.