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.
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.