Thanks for the clarification Helen. You didn't answer one bit -is there a
syntax for 'grant all on everything to USER'?

Hmmm - must find your book - think its gone walkabout.

Regards
Paul

> >
> >Fortunately I don't need to change an owner, just wondered what the
> process
> >was. I thought it was backup and restore under user to be the owner.
>
> That's correct. But the caution is that being the owner of a
> database doesn't make a user the owner of any objects created in the
> database. The owner of an object is (and remains) the user that created
> it.
>
> SYSDBA is like a "superowner", since it has full destructive rights
> to all databases and all objects in all databases. Hence the
> frequent advice seen here to make sure you create databases and
> database objects while logged in as the user that you plan to have as
> the owner.
>
> ./heLen