Re: Exporting User Rights

From: TurkBear <noone_at_nowhere.com>
Date: Tue, 22 May 2001 11:14:59 -0500
Message-ID: <1t3lgt8ksqa8uheb4ggms208pln9050td8@4ax.com>

AFAIK, no..users must be created in the target database prior to the import of any objects they own or have grants to... You can build a script to get the user/password info from the source database( the all_users table) and run it against the target to save typing... .[ you can get the default tablespaces, temporary, etc, as well but unless the tablespaces have the same names, you will need to assign rights, quotas, etc by hand]

"Nicolas Bronke" <newsgroup_at_trinity.de> wrote:

>Is it possible, like creating a dump-file, to export the user from a oracle
>database, so that they are created on a new/other database?
>
>Regards
>
>Nicolas
>
Received on Tue May 22 2001 - 11:14:59 CDT