Re: Copying userid,password from instance

Yes it is. You would need to capture the encrypted value of the password from the one
instance. I use a script that looks something like this:

    select 'create user'||username||' identified by values '''||password||''';'

    from dba_users where username = 'JONES';

so the output would look like:

    create user JONES identified by values 'ER12874SG834';

Terry Ball
Sr. DBA, CSG Systems

NiteOwl wrote:

> Hi,
>
> I wonder if the user's id and password could be copied
> from one Oracle instance to another.
> Example, I have the user accounts and password setup in
> a UAT database and I would like to copy into the
> production database.
>
> Thanks
> NiteOwl
Received on Tue Dec 01 1998 - 12:14:13 CST