Which SQL sublanguage is used for data access control?

Which SQL sublanguage is used for data access control?

• A. DDL
• B. DML
• C. DRL
• D. DCL

Answer: (D)

Controlling who can access and what they can do with data in a database is handled by the part of SQL that manages privileges. This sublanguage includes commands like GRANT to give permissions and REVOKE to withdraw them, allowing fine‑grained control over who can SELECT, INSERT, UPDATE, or DELETE data, or who can alter database objects. That focus on permissions is what makes it the data access control mechanism. DML handles actual data operations (reading and changing data) but not who is allowed to perform those operations. DDL manages the structure of the database (creating, altering, dropping objects). DRL isn’t a standard SQL sublanguage for access control.

Controlling who can access and what they can do with data in a database is handled by the part of SQL that manages privileges. This sublanguage includes commands like GRANT to give permissions and REVOKE to withdraw them, allowing fine‑grained control over who can SELECT, INSERT, UPDATE, or DELETE data, or who can alter database objects. That focus on permissions is what makes it the data access control mechanism.

DML handles actual data operations (reading and changing data) but not who is allowed to perform those operations. DDL manages the structure of the database (creating, altering, dropping objects). DRL isn’t a standard SQL sublanguage for access control.