Answer-first summary for fast verification
Answer: REVOKE ALL PRIVILEGES ON SCHEMA retail FROM former_employees;
The correct command to revoke all privileges from a group on a schema is `REVOKE ALL PRIVILEGES ON SCHEMA retail FROM former_employees;`. This command follows the syntax for revoking privileges, where `ALL PRIVILEGES` specifies that all privileges should be revoked, `ON SCHEMA retail` identifies the securable object, and `FROM former_employees` specifies the principal from which privileges are being revoked. This syntax is consistent with Databricks' documentation on privilege management.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which command correctly revokes all privileges from the group former_employees on the schema retail?
A
REMOVE ALL PRIVILEGES ON SCHEMA retail FROM former_employees;
B
REVOKE ALL PRIVILEGES ON SCHEMA retail FROM former_employees;
C
DELETE ALL PRIVILEGES ON SCHEMA retail FROM ‘former_employees‘;
D
REVOKE ALL PRIVILEGES FROM former_employees ON SCHEMA retail;
E
REMOVE ALL PRIVILEGES FROM ′former_employees′ ON SCHEMA retail ;
No comments yet.