Multiple choice technology databases

To create a private synonym in another user’s schema you must have the following privilege:

  1. CREATE SYNONYM

  2. CREATE ANY SYNONYM

  3. CREATE PUBLIC SYNONYM

  4. CREATE OTHER SYNONYM
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Creating private synonyms in other schemas requires special permissions beyond the basic CREATE SYNONYM privilege. The CREATE ANY SYNONYM privilege explicitly grants the ability to create synonyms in any user's schema, which is necessary when working across schema boundaries. CREATE SYNONYM only allows creating synonyms within your own schema context, while CREATE PUBLIC SYNONYM is for public synonyms only.

Keep practicing — related questions