Re: Exporting/Importing USER accounts

From: Dale Edgar <Dale_at_DataBee.com>
Date: Mon, 24 Jun 2002 09:33:21 +0000 (UTC)
Message-ID: <3d16e834.9786342_at_news.btclick.com>

Hi
>I recently imported several schemas from one Unix based DB to a fresh
>NT based one, which was set up fresh. But it was a pain since I had to
>recreate the corresponding users on the new DB, including their roles,
>privileges, etc.
>
>Is there a way to extract this information as DDL scripts from a full
>dump made with the export utility?

The freeware DBATool does exactly this. It can easily generate these DDL scripts for you.

DBATool: http://www.DataBee.com/dt_home.htm

Regards
Dale

---

DataBee: Create referentially correct small versions of large Oracle databases for development and test. http://www.DataBee.com Received on Mon Jun 24 2002 - 11:33:21 CEST