Dear all,

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;

Synonym created.

SQL> GRANT SELECT ON gt_ausp TO raventst
2 ;
GRANT SELECT ON gt_ausp TO raventst
*
ERROR at line 1:
ORA-02021: DDL operations are not allowed on a remote database

SQL>