Skip to Main Content
Forums

Oracle Database Discussions

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!

Generate create synonym statements dynamically

mike79Oct 24 2016 — edited Oct 24 2016

DB version: 11.2.0.4

User SCOTT has lots of tables in it. There is another user in the same DB called READ_USR .

This user already has read privileges on all tables in SCOTT schema. I want to dynamically generate following CREATE SYNONYM statements for all tables in Scott schema.

create synonym <synonymName> for scott.<tableName> ;

How can I do this ?
This post has been answered by Mathias Zarick on Oct 24 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2016
Added on Oct 24 2016
#general-database-discussions
2 comments
2,282 views