Hi Peter,

Guggi for Oracle supports reverse engineering of all objects
belonging to a given schema. Reverse engineering can be done as
follows:

1. Login to Guggi for Oracle as the schema user.
2. Go to menu option Tools and select Reverse Engineer
3. In the drop down box, select the schema you wish to reverse
engineer. In this case it will be same as the schema user you logged
in as.

Note: You can login as any user and reverse engineer the objects of
a different schema AS LONG AS the user you logged in as has the
permission to access the objects of the schema you wish to reverse
engineer.

4. Select the objects to be reverse engineered. By clicking on the
Table checkbox, all the tables will be selected. Similarly other
objects can be selected.

5. Select whether you wish to save the reverse-engineered SQL to be
saved to a file or not.

6. Click the first toolbar button to start the reverse engineering
process.

You can also choose whether you want the storage information,
insexes, constraints etc. The file so generated will have all the
DDL for the selected database objects.

You can reverse engineer advanced objects for Oracle 9i upwards.
Reverse engineering of tables, views, PL/SQL code and other major
object types is supported for Oracle 8 and upwards.


Please let me know if you have any more questions.

Thanks

Shakti



--- In guggiusers@yahoogroups.com, "peterka7819" <pabend@...> wrote:
>
> I was wondering if there is a way in Guggi to "reverse engineer" a
> user in order to get the SQL to recreate the user? In other words,
I
> would like to get an SQL script via Guggi that I could then run in
> another database to create the user with the same object and system
> privileges as in the original database.
>
> Any help would be appreciated.
>