Hi @Cami, To grant a developer the ability to execute the SHOW GROUPS WITH USER '***@***' query without requiring admin permissions on Azure Databricks, you can follow these steps:
Unity Catalog Privileges:
Unity Catalog is the metadata service in Azure Databricks. It allows you to manage access to data and other objects.
By default, users have no access to data in a metastore. Youโll need to grant specific privileges to allow the developer to execute the query.
Welcome to Databricks Community: Lets learn, network and celebrate together
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.