Explanation:
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.
Ultimate access to all questions.
No comments yet.
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 ;