Skip to Main Content

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!

grant or create synonym in bulk

Tony007Feb 24 2018 — edited Feb 24 2018

hi i have the following use case, i have two schema

hr and hr2

all my database objects are in schema hr2 but developer can only user hr and also the application how can i grant all object ins schema h2 to hr schema i dont what to do one by one i what to do in bulk am in 12c

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2018
Added on Feb 24 2018
5 comments
524 views