When doing a full export, SYS objects are not included so on import
you need to re-grant any SYS grants from the source db.
A full export is not 'full' in the sense that it excludes SYS.
Rick Denoire <100.17706_at_germanynet.de> wrote in message news:<e7l0iv4q8t73ut7kp4lcaacj63dk2h7bc7_at_4ax.com>...
> I created an empty DB with appropriate tablespaces in order to do a
> full import from another DB.
>
> It turned out that object privileges on SYS objects granted to an
> account in the source DB were not transfered to the destination DB
> after the full import (otherwise everything else went well). Is that
> the way it should work? So one can not rely that a full import is
> really full? This user is supposed to have select access on tables
> like all_users, v$session, etc. By the way, SYS password changed to
> that of the source DB! Funny.
>
> Bye
> Rick Denoire
Received on Thu Jul 24 2003 - 21:04:22 CDT
