CREATE ANY SYNONYM - Create private synonym in another users schema

Q.  Which privilege from the following is used to create a private synonym in another user's schema?
- Published on 12 Aug 15

a. CREATE SYNONYM
b. CREATE ANY SYNONYM
c. CREATE PUBLIC SYNONYM
d. None of the above

ANSWER: CREATE ANY SYNONYM
 

    Discussion

  • Nirja Shah   -Posted on 29 Sep 15
    To create a private synonym in your own schema, you must have the CREATE SYNONYM system privilege.

    To create a private synonym in another user's schema, you must have the CREATE ANY SYNONYM system privilege.

    To create a PUBLIC synonym, you must have the CREATE PUBLIC SYNONYM system privilege.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)