Create user question

Hi,

I have created a new user in an oracle database. Unfortunately that user

does not have access to the tables in the database which are created by another user. I guess it has something to do with de schema. How do you give access to a newly created user to access all the tables and views in the database.
Is there a simple way to do that or do you have to grant alle tables to that users, that would be a bit clumsy if you have a couple of hundred tables and views.

regards Johan den Boer

email : jj.den.boer_at_hccnet.nl Received on Sun Aug 22 1999 - 05:04:54 CDT