Which of the following technique can be used to implement fine-grained access control to rows and columns of the Delta table based on the user’s access?

Which of the following technique can be used to implement fine-grained access control to rows and columns of the Delta table based on the user’s access?
A . Use Unity catalog to grant access to rows and columns
B. Row and column access control lists
C. Use dynamic view functions
D. Data access control lists
E. Dynamic Access control lists with Unity Catalog

Answer: C

Explanation:

The answer is, Use dynamic view functions.

Here is an example that limits access to rows based on the user being part managers group, in the below view if a user is not a part of the manager’s group you can only see rows where the total amount is <= 1000000

Dynamic view function to filter rows

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments