I have a synonym to remote table via db link and I am trying to grant all on that to a role since application user access objects to a role.
I am getting this error:
grant all on trans_version to hpdevel
ERROR at line 1:
ORA-02021: DDL operations are not allowed on a remote database
trans_version is a synonym to remote object via db link.
Is there any fix other than creating the table locally.