CISSP Question #62: Real Exam Question with Answer & Explanation

The correct answer is B: GRANT and REVOKE.. The Structured Query Language (SQL) implements Discretionary Access Controls (DAC) using the GRANT and REVOKE commands. DAC is a type of access control that allows the owner or creator of an object, such as a table, view, or procedure, to grant or revoke permissions to other user

Submitted by diego_uy· Mar 5, 2026Identity and Access Management

Question

The Structured Query Language (SQL) implements Discretionary Access Controls (DAC) using

Options

AINSERT and DELETE.
BGRANT and REVOKE.
CPUBLIC and PRIVATE.
DROLLBACK and TERMINATE.

Explanation

The Structured Query Language (SQL) implements Discretionary Access Controls (DAC) using the GRANT and REVOKE commands. DAC is a type of access control that allows the owner or creator of an object, such as a table, view, or procedure, to grant or revoke permissions to other users or roles. For example, a user can grant SELECT, INSERT, UPDATE, or DELETE privileges to another user on a specific table, or revoke them if needed.

Topics

#SQL security#Discretionary Access Control#GRANT/REVOKE

Community Discussion

No community discussion yet for this question.

Full CISSP Practice Browse All CISSP Questions