Re: Copy user schema without data (Password problem)

It works

alter user x identified by values 'xxxxx' - use single quotes.

Mark

<samger_at_my-deja.com> wrote in message news:7rrr56$37f$1_at_nnrp1.deja.com...
>
>
> 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.
Received on Thu Sep 16 1999 - 22:32:42 CDT