A DBA creates a view for Bob which joins Tables 1 and 2. Bob runs a SELECT statement on the view and is able to see the result. Alice tries to run the same SELECT query on the same View, which the DBA also has given her access to, but is unable to see the same results. Why is this so?

Question

Accepted Answer

Alice may not have permissions to Table 1 or Table 2, or both.

Answer

Bob has a higher privilege rating than Alice on the View.

Answer

Alice may not have permissions to Table 1 and Table 2 in conjunction.

Answer

This scenario is impossible as both Alice and Bob should be able to execute the SELECT query on the View since they already have permissions.

Crowdly

A DBA creates a view for Bob which joins Tables 1 and 2. Bob runs a SELECT state...

Want instant access to all verified answers on ebwise.mmu.edu.my?