Multiple choice technology databases

If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure ?

  1. No

  2. Yes

  3. Can't Say

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle, if you have EXECUTE privilege on a procedure in another user's schema, you CAN execute that procedure even without direct privileges on the tables it accesses. This works because of definer's rights - the procedure runs with the privileges of its owner (the schema that owns it), not the privileges of the user calling it.

Keep practicing — related questions