Answer-first summary for fast verification
Answer: GRANT ALL PRIVILEGES ON TABLE employees TO hr_team
The correct command to grant full permissions on an object to a user or group is `GRANT ALL PRIVILEGES ON TABLE employees TO hr_team`. This command is translated into all the necessary privileges: SELECT, CREATE, MODIFY, USAGE, and READ_METADATA. For more details, refer to the [Databricks documentation on object privileges](https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#privileges).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What command should a data engineer use to grant the HR team full permissions on the 'employees' table?
A
GRANT ALL PRIVILEGES ON TABLE hr_team TO employees
B
GRANT SELECT, MODIFY, CREATE, READ_METADATA ON TABLE employees TO hr_team
C
GRANT FULL PRIVILEGES ON TABLE hr_team TO employees
D
GRANT ALL PRIVILEGES ON TABLE employees TO hr_team
E
GRANT FULL PRIVILEGES ON TABLE employees TO hr_team
No comments yet.