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?
Grégory GRIN wrote:
>
> You can use import/export oracle utilites with the option fromuser /
> touser
> > 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
Hi!
Using the above parameters will copy the users' objects (tables, views, etc.) and grants but not the accounts, passwords and roles. The accounts specified in TOUSER parameter will have to be created manually before the import.
What you are asking can rather be achieved using export with FULL=Y Depending on your setting of ROWS=Y/N it will/not bring over the data in users' tables.
So far as I know, it is impossible not to import users' objects if one uses export/import, so if you don't want your users' objects, you will have to manually delete them afterward.
Alternatively, find all
CREATE USER ..., CREATE ROLE..., and GRANT commands in the export file
and issue them from sqlplus -- I have never tried this but it should
work.
Thanks.
k&
Received on Tue Nov 10 1998 - 16:37:23 CST