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!

How to give select privilege to all Schema objects?

570355May 11 2011 — edited May 11 2011
Hi,

We have many users and Schemas.
One user wants to run "select" for all tables of other Schema.

For example: TEST user wants to select TEST2's objects. TEST2 have hundred tables but TEST user cannot select any other Schema objects so I don't want to give SELECT ANY TABLE privileges.

how can do that in one time? is it possible to give grants all Schema objects one time?
db versin. 9.2.0.8

regards & thanks
This post has been answered by JustinCave on May 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2011
Added on May 11 2011
#9i, #data, #database, #dba, #general-database-discussions, #oracle, #query, #sql-developer, #table
2 comments
3,746 views