Re: help:move users to another database

From: Anurag Varma <avdbi_at_nospam.hotmail.com>
Date: Tue, 04 Sep 2001 21:35:24 GMT
Message-ID: <wObl7.1234$k51.418236@news02.optonline.net>

<u518615722_at_spawnkill.ip-mobilphone.net> wrote in message news:l.999634100.1998138427@[64.94.198.252]...
>do we have to give users all the grants as the original database does or
the import utility will do it for us?

GRANTS=Y on import will import object privs. However if export was a user-mode export, the export file contains only those grants granted by owner.

See syntax at:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76955/ch02.htm#42461

Anurag Received on Tue Sep 04 2001 - 16:35:24 CDT