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

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

Options

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

How the community answered

(41 responses)

A
7% (3)
B
88% (36)
C
2% (1)
D
2% (1)

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