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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Granting entire Schema access ?

johnpau2013May 5 2012 — edited May 5 2012

- We have database user "A" with several tables,views...etc (thousands of objects)

- We created a new database user "B". Is there a simple way of granting all ON user A objects to B ?
without writing some scripts ?

We want user B able to access everything which user A owns.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 2 2012

Added on May 5 2012

#general-database-discussions

9 comments

39,895 views

Oracle Database Discussions

Granting entire Schema access ?

Comments

Post Details