workaround to perform DDL operations on remote database

[leonard905]

Hi all,

Is there a workaround to the error:
ORA-02021: DDL operations are not allowed on a remote database.

I created private synonyms connecting to remote database via dblink and want to grant select to the synonyms to other users.
Any idea how I can do this.

Thanks in advance,
Leo

[leonard905]

Closed thread.

I was able to find a workaround by creating a view based on the synonym and creating a public synonym to the view, then finally granting select on the view to other users.

Thanks,
Leo