ORA-02021: DDL operations are not allowed on a remote database
I have the following problem:
I have 2 databases A and B with a databaselink from A to B.
On B I created public synonyms for the db objects I need from A.
I also need to do some selects/updates/deletes/inserts on tables and executes stored procedures on A from B.
When I do grant select or insert... or grant the execute for stored procs, I get an Oracle error
that dml action not allowed on remote database:
ORA-02021: DDL operations are not allowed on a remote database
Is this a restriction from Oracle or is there a way around it or what am I missing?
Thanks!