Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to grant "select" between remote schema

385272Aug 30 2004 — edited Aug 31 2004

Folks,

I have created public synonym tables in my target db and I am trying to grant SELECT privilege on my target schema so that these tables can be executable in deployment Manager. My source and target shema are in two different databases and are connect through a db link.

I ran this statement:
GRANT SELECT ON SOURCE_TABLE TO TARGET_SCHEMA
and I am getting this error:
ORA-02021: DDL operations are not allowed on a remote database
Am I missing something or does the target_schema need some extra privileges?

Any help will be greatly appreciated.

Thanks.

Ak

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2004

Added on Aug 30 2004

#data-warehousing, #warehouse-builder

3 comments

464 views