exam questions

Exam 1z0-149 All Questions

View all questions & answers for the 1z0-149 exam

Exam 1z0-149 topic 1 question 29 discussion

Actual exam question from Oracle's 1z0-149
Question #: 29
Topic #: 1
[All 1z0-149 Questions]

Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

  • A. It results in an error because Authid Current_User is missing from MYPROC.
  • B. It results in an error because Authid Definer is missing from MYPROC.
  • C. It results in an error because USERB doesn't have select privilege on USERA.EMP.
  • D. It executes successfully.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Pietro
5 months, 3 weeks ago
D - If the AUTHID clause is not specified, Oracle will default to using the AUTHID DEFINER
upvoted 3 times
...
TheOracleWasTaken
11 months ago
D tested out. Because you're executing as definer's rights so even if its selecting from a table where UserB doesnt have any rights on, its executing as if he's userA who does have rights.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago