ORA-02021: DDL operations are not allowed on a remote database
I want users on database A to have select privilege on tables on remote database B.
I want to add the select privilege to a role which exists on database A.
grant select on table_owner.table_name@B to role
/
I get the error
ORA-02021: DDL operations are not allowed on a remote database
What is the best way to go about giving users on database A select privilege on tables on database B.
FYI
this is how I created my dblink on database A
create public database link B.world connect to owner identified by password using ‘B’;
I want to add the select privilege to a role which exists on database A.
grant select on table_owner.table_name@B to role
/
I get the error
ORA-02021: DDL operations are not allowed on a remote database
What is the best way to go about giving users on database A select privilege on tables on database B.
FYI
this is how I created my dblink on database A
create public database link B.world connect to owner identified by password using ‘B’;
0