Re: Need a script to export/import user information & privileges

From: Holger Heidenbluth <heidenbluth_at_nis-rheinsberg.de>
Date: Mon, 18 Dec 2000 08:27:39 +0100
Message-ID: <3a3dbcf0$0$8782$4dbef881@businessnews.de.uu.net>

The Oracle export/import utility generates a dump (including objects definitions, privileges, data) that you can import into another database.

The Reverse/DDL engineer from KeepTool generates the complete DDL script of a database schema. It includes all objects definition, privileges (granted + received). Look at www.KeepTool.com

Best Regards
Holger

Frank Dünschede <Frank.Duenschede_at_t-online.de> schrieb in im Newsbeitrag: 91g1q3$5ag$07$1_at_news.t-online.com...
> Hello all,
>
> I hope there is someone that could help me!
>
> I need a script that can export a complete set of users with all their
> privileges (that is table-/object-/systemprivileges) and roles from one
> Oracle8i DB and that can import these users (with all these privs) into
> another Oracle8i DB.
>
> Any suggestions?
>
> --Thanks in advance, FD.
>
>
>
>
Received on Mon Dec 18 2000 - 01:27:39 CST