Re: Full import is not really "full"

From: Tanel Poder <tanel_at_@peldik.com>
Date: Fri, 25 Jul 2003 14:39:23 +0300
Message-ID: <3f2116eb$1_1@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:39:23 CDT