Database Administration (MOSC)

MOSC Banner

ORA-02021: DDL operations are not allowed on a remote database

edited Dec 23, 2013 1:31AM in Database Administration (MOSC) 11 commentsAnswered
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’;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center