Re: Full import is not really "full"

A little addition, that for sys and system alter user command is given to change their passwords and temporary tablespace, for others, create user is used. Makes sense, since sys and system should always exist in a functional database.

Tanel.

"Tanel Poder" <tanel@@peldik.com> wrote in message news:3f2116eb$1_1_at_news.estpak.ee...
> Hi!
>
> During full export, all user definitions, including SYS with it's
encrypted
> password are exported.
>
> Tanel.
>
> > It's exactly the way it's supposed to work. Nothing owned by SYS
> (including
> > his password) can ever be exported; and neither can anything granted by
> > SYS. Which is (1) why import can certainly be a bit problematic and (2)
> you
> > should never get into the habit of logging on as SYS except to do
> startups,
> > shutdowns, backups and recoveries (use SYSTEM instead).
> >
> > Incidentally, every user has rights to the all_ views automatically,
> > without the need for a special grant.
> >
> > The V$ views, fair enough.
> >
> > ~QM
>
>
Received on Fri Jul 25 2003 - 06:44:17 CDT