Accessing Table of other owner

[tpereira]

Thanks,
the solution post by davey23uk (Alter Session command) resolve my problem.
With this solution, the USER2 can do only SELECT on TB_TEST1 without the owner.

Very Good solution.
Congratulation.

[davey23uk]

wasnt my solution, but glad you got it working

[srt]

I hope this should help.

1) Create a role and grant select on table to role.
2) Grant role to each user.
3) Create public synonyms.

This way from next time when you create tables there will be less effort to give access on tables to users.

You dont need to give 100 commands for 100 users. use vi editor and make the changes and run the script in database.
it just takes 5-10 min to do this.

Thanks