Import bug (one last word)

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 2 Jul 2002 10:01:56 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7024F1AF1@lnewton.leeds.lfs.co.uk>

Chuck,

you wrote, regarding IMP being a special case and doing spacial things :

>> My argument on this is that it does
>> things that you normally can't do even as a DBA. It allows a DBA
doing a
>> full import to grant permissions on tables he does not own.

But my point, in my last post, was this :

IMP carries out a CONNECT to the user being imported. Then it does the grants to other users.

So the DBA user is NOT doing anything different at all.

Check it out, run an imp with indexfile=somefile.txt then edit the somefile.txt output.
You will see, a CONNECT USERNAME, where USERNAME is the one being imported.

Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Tue Jul 02 2002 - 04:01:56 CDT