Full import is not really "full"

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Thu, 24 Jul 2003 23:57:39 +0200
Message-ID: <e7l0iv4q8t73ut7kp4lcaacj63dk2h7bc7@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 - 16:57:39 CDT