Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I copy Oracle user accounts from 1 instance to another?

Re: Can I copy Oracle user accounts from 1 instance to another?

From: Kirill Richine <krichine_at_radss.com>
Date: Tue, 10 Nov 1998 15:37:23 -0700
Message-ID: <3648C023.B6AFDF06@radss.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US