Skip to Main Content
Forums

SQL & PL/SQL

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 access to multiple tables to user

778109May 18 2012 — edited May 18 2012
Hi forum members,

Am an Oracle,PL/SQl newbie. A request has come from client.There is a database with two different User/Schema -- ABC & XYZ.

Each schema has its own set of tables.

Now,our client wants to access(select access only) all the tables of XYZ schema from ABC schema.Now,there are more than 200 tables in XYZ schema,hence its cumbersome to run the same grant select query again and again.Could anyone help me about a query that would do the job in one go?

NB:Client logs into the two schema using the ABC and XYZ usernames only.

Oracle -11g

Many thanks

Edited by: user1128836 on May 18, 2012 2:31 AM
This post has been answered by Rob Schoenmakers on May 18 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2012
Added on May 18 2012
#11g, #pl-sql
5 comments
7,382 views