Answer-first summary for fast verification
Answer: GRANT USAGE ON DATABASE customers TO team;
To grant permission for a team to access and see the existing tables in a database, the 'USAGE' permission on the database is required. The correct command to grant this permission on the 'customers' database to the new team is 'GRANT USAGE ON DATABASE customers TO team;'. The other options either provide incorrect privileges or are directed to the wrong entities.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A new data engineering team has been assigned to work on a project involving the analysis of existing customer data. To effectively carry out their tasks, the team requires access to the database named 'customers' to inspect the existing tables and their structures. The team operates under its own designated group. Which SQL command should you use to grant the necessary permissions on the entire 'customers' database to the new team?
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 USAGE ON DATABASE customers TO team;
No comments yet.