Re: Full import is not really "full"

On Fri, 25 Jul 2003 14:39:23 +0300, Tanel Poder <tanel@@peldik.com> wrote:

> Hi!
>
> During full export, all user definitions, including SYS with it's
> encrypted
> password are exported.
>
> Tanel.
>

It's not encrypted. It's hashed.

~QM

>> 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
>
>
>

-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/