DROP ANY SYNONYM system privilege - Drop private synonym in another users schema - Oracle

Discussion

• Nirja Shah   -Posted on 30 Sep 15
  - You can drop any private synonym in your own schema.
  
  - To drop a private synonym in another user's schema, you must have the DROP ANY SYNONYM system privilege.
  
  - To drop a public synonym, you must have the DROP PUBLIC SYNONYM system privilege.
  
  - Drop a synonym that is no longer required using DROP SYNONYM statement.
  
  - To drop a private synonym, omit the PUBLIC keyword.
  
  - To drop a public synonym, include the PUBLIC keyword.
  
  - For example, the following statement drops the private synonym named emp:
  
  DROP SYNONYM emp;
  
  - The following statement drops the public synonym named public_emp:
  
  DROP PUBLIC SYNONYM public_emp;
  
  - When you drop a synonym, its definition is removed from the data dictionary.
  
  - All objects that reference a dropped synonym remain.
  
  - However, they become invalid (not usable).

➨ Post your comment / Share knowledge