How do I grant access to find a table in Databricks, without giving access to query the table?

[excavator-matt]

Hi!

By default it seems users can only see tables and views in Unity Catalog that they have SELECT permission/privilege on. However, we would like to use Unity Catalog as a data catalog of tables we have. They wouldn't then be able to request access to query.

How can I grant users permissions to see the table/view without granting them access to query the table/view?

We have tried all combinations of privileges, but nothing seems to work. There is a feature for requesting access, but when would that ever be used if they can't see objects they do not already have access to?

[iyashk-DB · Accepted solution]

@excavator-matt you can grant BROWSE privilege on your catalog to a broad audience (for example, the “All account users” group). This lets users see object metadata (names, comments, lineage, search results, information_schema, etc.) in Catalog Explorer and search without being able to read data. They do not need USE CATALOG or USE SCHEMA to read metadata when they have BROWSE on the catalog.

[excavator-matt]

Nice! I had completely missed that catalog level privilege. Are there any plans to extend this to a schema level? I want to protect the users from being cluttered with staging stables from other teams. I could of course also introduce more catalogs, but this also seems excessive.

[Shivam7788775]

@excavator-matt to make tables and views discoverable without exposing their data, you should use the BROWSE privilege at the catalog level.

Granting BROWSE on a catalog (for example to the All-account users' group) allows users to view metadata across multiple surfaces—not just Catalog Explorer—including the schema browser, search results, lineage graph, information schema, and REST APIs. This does not allow them to query or read the underlying data.

An important detail is that BROWSE works independently of USE CATALOG and USE SCHEMA. As long as a user has BROWSE on the catalog, they can see metadata even if those other privileges are not granted.

This is the intended mechanism in Unity Catalog for object discovery while keeping data access tightly controlled.

[community_user_]

@Shivam7788775 Hello, I have a similar question about the BROWSE permission management.

We have three tables A, B, C in the same schema, I want to grant user only permission to view the only metadata of table A, cannot see underlying data of A. User cannot see table B and C including table schema and underlying  data.

Is it possible to do this ?