Oracle
1Z0-074 · Question #57
Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema. BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker's right. BIXBY…
The correct answer is C. CUST_RECORDS table in Rlayton's schema. Explanation/Reference:
New Features for Security
Question
Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema. BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker’s right. BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user. When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?
Options
- ACUST_RECORDS table in Bixby's schema
- BCUST_RECORDS table in Murdok's schema
- CCUST_RECORDS table in Rlayton's schema
- DCUST_RECORDS table in the schema of Bixby and Rlayton
- ECUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok
How the community answered
(52 responses)- A15% (8)
- B2% (1)
- C71% (37)
- D8% (4)
- E4% (2)
Explanation
Explanation/Reference:
Topics
#invoker's rights#definer's rights#procedure execution#schema resolution
Community Discussion
No community discussion yet for this question.