One of your users has created a table (John.table1) and granted Samantha Select permission of the table. Samantha, however, does not need to see all the data in the table so she create a view (Samantha.view1). Thomas now wants access to Samantha’s view, so Samantha grants Thomas Select permission on the view. What happens when Thomas tries to select from the view?

One of your users has created a table (John.table1) and granted Samantha Select permission of the table. Samantha, however, does not need to see all the data in the table so she create a view (Samantha.view1). Thomas now wants access to Samantha’s view, so Samantha grants Thomas Select permission on the view. What happens when Thomas tries to select from the view?

One of your users has created a table (John.table1) and granted Samantha Select permission of the table. Samantha, however, does not need to see all the data in the table so she create a view (Samantha.view1). Thomas now wants access to Samantha’s view, so Samantha grants Thomas Select permission on the view. What happens when Thomas tries to select from the view?


Answer: – Thomas cannot select from the view because he does not have permission on the underlying table, so the ownership chain breaks.

(Because the ownership chain is broken, Thomas cannot select from the view unless he is granted Select permission on the underlying table (John.table1).)