A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team. Which…

The correct answer is E. GRANT USAGE ON DATABASE customers TO team;6. The USAGE privilege on a database allows a user or group to navigate into the database and see (list) its contents, including tables and views - without granting the ability to read data from those tables. This is the minimal permission needed to 'see what tables already…

Submitted by ashley.k· Apr 18, 2026Databricks Lakehouse Platform

Question

A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team. Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

Options

AGRANT VIEW ON CATALOG customers TO team;
BGRANT CREATE ON DATABASE customers TO team;
CGRANT USAGE ON CATALOG team TO customers;
DGRANT CREATE ON DATABASE team TO customers;
EGRANT USAGE ON DATABASE customers TO team;6

How the community answered

(31 responses)

A
3% (1)
C
3% (1)
E
94% (29)

Explanation

The USAGE privilege on a database allows a user or group to navigate into the database and see (list) its contents, including tables and views - without granting the ability to read data from those tables. This is the minimal permission needed to 'see what tables already exist.' GRANT USAGE ON DATABASE customers TO team is the correct syntax. Option A incorrectly uses the CATALOG keyword and VIEW privilege. Options B and D use CREATE, which grants the ability to create new objects, not browse existing ones. Option C reverses the database and team names.

Topics

#SQL Permissions#Access Control#Databricks Security#Database Management

Community Discussion

No community discussion yet for this question.

Full DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice