Re: rename users

Hi

If I create a new user I have to export the old user and then doing:fromuser=old_user touser=new_user. If I have to change over 500 users, this will take tooooooo long.

The esy thing to do, is renaming a username but how?

That why

Thanks

Jan Birk

TurkBear skrev i meddelelsen <363e3066.28522933_at_news2.mm.com>...
>"Jan Birk" <jbirk_at_relief.dk> wrote:
>
>>Hi
>>
>>How can I rename a user? Why hasn't Oracle got a "alter user 'user_name'
to
>>'user_name';" or mayby it has?
>>
>>However, how can I simply change a user name?
>>
>>Thank you
>>
>>
>>Jan Birk
>>
>>
>Not to be a smart-a.. but, why? - You could just create a new user ( if you
have
>the enterprise tools, use create like... ) and then drop the old one....
>
>
>To reply please remove the 'nospam' part of the address
Received on Tue Nov 03 1998 - 00:58:43 CST