User-facing table access control

Diving further into the security model, let’s discuss table access control. In essence, table access control requires programming a user’s privileges to perform operations on a data object/asset. The owners of data objects or administrators will implement this programming with standard database security statements.

First, we will discuss users, objects, operations, and privileges. Then, we will bring them all together and see how we can program them with user-facing table access control.

Users, groups, and service principals

Databricks SQL inherits users and groups from the Databricks Lakehouse platform. Users and groups can be managed from the Admin Console area of the Databricks platform.

Note to Administrators

At the time of writing, user and group management is only available from the Data Science & Engineering and the Machine Learning persona experiences.

If you are using Unity Catalog, you should create account...