Answer-first summary for fast verification
Answer: GRANT USAGE ON DATABASE customers TO team;
The correct command is 'GRANT USAGE ON DATABASE customers TO team;'. The USAGE privilege allows the team to see the tables that exist in the database. Other commands are either incorrect in syntax or do not provide the necessary permission to view the tables. Specifically, 'GRANT VIEW' is not a valid privilege type in Databricks SQL, and the other options either attempt to grant permissions on the wrong objects or provide the wrong privileges.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A newly formed data engineering team has been tasked with working on a specific project that requires interaction with an existing database named "customers". The team needs to be able to view and interact with all tables within this database to effectively carry out their project tasks. The team belongs to a specific user group within the organization. Which of the following SQL commands can be used to grant the required permissions on the entire "customers" database to this new user group?
A
GRANT VIEW ON CATALOG customers TO team;
B
GRANT CREATE ON DATABASE customers TO team;
C
GRANT USAGE ON CATALOG team TO customers;
D
GRANT CREATE ON DATABASE team TO customers;
E
GRANT USAGE ON DATABASE customers TO team;
No comments yet.