Question: USERB creates a function called SEL _ PROC which includes the statement: SELECT . . . FROM usera.employees . . . ; USERC needs to
USERB creates a function called SELPROC which includes the statement: SELECT FROM usera.employees ; USERC needs to execute UserB's procedure. What privileges are needed for this to work correctly? Choose two.Choose all correct answers UserA needs EXECUTE on userB.selproc UserC needs SELECT on userA.employees UserC needs EXECUTE on userB.selproc UserB needs SELECT on userA.employees UserC needs EXECUTE on Userb
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
