Re: Create user question

I guess the best way would be to create a role with all the privileges you want, and then grant the role to subsequent users created. - Aziz

Johan den Boer wrote:

> 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 Wed Sep 22 1999 - 10:52:16 CDT