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!

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

40,021 views