Here is my situation. I am creating synonym for the table which is in Remote database. Synonym creation is successful. After that, i am granting select privileges on synonym to other schema's in the same database. How do i resolve this.
I can create the same synonym in all other schema's. But i do not want that.
SQL> CREATE SYNONYM gt_ausp FOR infsapi.AUSP@odsprd_i_box;
SQL> GRANT SELECT ON gt_ausp TO raventst
GRANT SELECT ON gt_ausp TO raventst
ERROR at line 1:
ORA-02021: DDL operations are not allowed on a remote database