Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I copy Oracle user accounts from 1 instance to another?
This will also bring back all that users objects...
Grégory GRIN <grin_at_club-internet.fr> wrote in article
<36378692.A7D687B6_at_club-internet.fr>...
> You can use import/export oracle utilites with the option fromuser /
> touser
>
> Example :
>
> exp user/pwd_at_sid1 compress=Y file=/ExpFiles/exp_user.dmp
> log=/oralog/exp_user.log
>
> imp system/pwd_at_sid2 fromuser=user touser=user
> file=/ExpFiles/exp_user.dmp log=/oralog/imp_user.log
>
> Greg
>
>
> >
> > Question: I have user accounts created in 1 instance that I would like
to
> > duplicate in another instance. I want to grab the user account,
password,
> > grants & roles specifically
> >
> > Does anyone have a solution?
> >
> > Stephanie
>
Received on Wed Oct 28 1998 - 18:15:36 CST