Re: Copy user schema without data (Password problem)

Hello,

This is correct sql command for you to set the same passwords in new database;

select
  'alter user ',username,' identified by values '''||password||''';' from dba_users;

Rafal Czekala (czekala_at_real.pl)
Oracle DBA

In article <7rrr56$37f$1_at_nnrp1.deja.com>,   samger_at_my-deja.com wrote:
>
>
> Hi folks,
>
> system : 8.0.5.2 - what I want is to create a user "like" on a
different
> database.
>
> To get all the information I select form dba_users
>
> username,
> default_tablespace,
> temporary_tablespace
>
> grants are not the problem - the problem is the password.
>
> How could i set the passwort on a different database like the passwort
> on the main database for one special user.
>
> exmpl:
>
> select 'alter user '||user_name||' identified by '||password||'
> from dba_users;
>
> password is decoded - i thought there was something like
> 'alter user x identified by values "xxxxx"' - but that does not
> work.
>
> any idea ?
>
> thx
> Alexander
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 17 1999 - 05:39:52 CDT