ORA-02021: DDL operations are not allowed on a remote database
669673Apr 23 2009 — edited Apr 23 2009Hi
I need to give SELECT grants to a role over a synonym but I got this error:
SQL> GRANT SELECT ON SYNERGIA.CoDato_SED TO ROLE_SYNERGIA;
GRANT SELECT ON SYNERGIA.CoDato_SED TO ROLE_SYNERGIA
*
ERROR at line 1:
ORA-02021: DDL operations are not allowed on a remote database
SYNERGIA.CoDato_SED is a synonym from a remote database create with this script:
CREATE SYNONYM SYNERGIA.CoDato_SED FOR TPS.CoDato_SED@BDEEDN.DSYN;
Please how can I deal with these situation.
Thanks.
----------------------------------------------------
Database version: Oracle 9i 9.2.0.8.0
SO: hpux 11.23