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