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

From: Hans Breemer <meterkast_at_zonnet.nlX>
Date: Mon, 18 Dec 2000 10:01:22 +0100
Message-ID: <%jk%5.1106$iB1.29155@zonnet-reader-1>

Holger,

I've done this many times using DBArtisan (from Embarcadero Software). Easy intuitive interface, even an Oracle no-no like me can do it.

Hans

"Holger Heidenbluth" <heidenbluth_at_nis-rheinsberg.de> wrote in message news:3a3dbc08$0$8779$4dbef881_at_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:
> 91g27c$29s$04$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 - 03:01:22 CST