
SELECT vendor_name FROM vendors WHERE vendor_id = 1;


GRANT CREATE PUBLIC SYNONYM, 
      DROP PUBLIC SYNONYM 
      TO ap_user;


CREATE PUBLIC SYNONYM vendors FOR ap.vendors;


SELECT vendor_name FROM vendors WHERE vendor_id = 1;

DROP PUBLIC SYNONYM vendors;