Answer-first summary for fast verification
Answer: GRANT ALL PRIVILEGES ON DATABASE customers TO DATABASE
In Databricks SQL, the `GRANT ALL PRIVILEGES` command provides the specified user or group with full access rights to the database, including the ability to read, write, modify, and manage objects within it. This is appropriate when a team needs complete control over a database for an ELT project. Other options like `GRANT USAGE` or `GRANT SELECT` only provide limited access, such as the ability to reference the database or read data, but not to modify or manage it.
Author: N L.
Ultimate access to all questions.
A new data engineering team has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to manage the project. Which of the following commands can be used to grant full permissions on the database to the new data engineering team?
A
GRANT USAGE ON DATABASE customers TO team;
B
GRANT ALL PRIVILEGES ON DATABASE customers TO team;
C
GRANT SELECT PRIVILEGES ON DATABASE customers TO team;
D
GRANT SELECT, CREATE, MODIFY ON DATABASE customers TO team;
E
GRANT ALL PRIVILEGES ON DATABASE customers TO DATABASE
No comments yet.