Granting access to objects to the user

In this recipe, you will learn how to grant access to objects to users so that they can write queries for analyzing data. We have already seen how users are created in the How to create a user in Databricks SQL recipe of this chapter.

Getting ready

Before you start on this recipe, make sure you have gone through the How to create a user in Databricks SQL recipe in this chapter and that all the resources mentioned in the Technical requirements section are ready for usage.

Also, run the following notebook to create Customer and Orders external Delta tables:

https://github.com/PacktPublishing/Azure-Databricks-Cookbook/blob/main/Chapter06/6_1.Reading%20Writing%20to%20Delta%20Tables.ipynb.

How to do it…

Let's run through the following commands to grant access to a user:

1. Execute the following command to grant access to a user or principal to the default database:

   GRANT USAGE ON DATABASE default TO `[e-mail]...