Intermediate
Database Management Systems
Q77 / 100
What is the purpose of the GRANT and REVOKE statements in SQL?
Correct! Well done.
Incorrect.
The correct answer is D) To assign and remove user privileges on database objects, forming the Data Control Language (DCL) portion of SQL
D
Correct Answer
To assign and remove user privileges on database objects, forming the Data Control Language (DCL) portion of SQL
Explanation
GRANT SELECT ON table TO user and REVOKE SELECT ON table FROM user manage access permissions at the object level. Together with DENY in some systems, they form DCL, the part of SQL responsible for security and authorization.
Progress
77/100