Re: Newbie: User needs to change password

Alternatively, you can use the SQL*Plus PASSWORD command:

SQL> create user test identified by test;

User created.

SQL> grant connect, resource to test;

Grant succeeded.

SQL> connect test/test;
Connected.
SQL> password
Changing password for TEST
Old password:
New password:
Retype new password:
Password changed
SQL> Alison

Steve Ashmore wrote:
> You need to;
>
> grant alter session to <userid>;
>
> But it would be better to grant it through a role.
>
> Then the user can:
>
> alter user <userid> identified by <newpassword>;
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
> Author of: 'So You Want to be an Oracle DBA?'
>
> "Patrick L. Nolan" <pln_at_cosmic.stanford.edu> wrote in message
> news:b3elbc$dfn$1_at_news.Stanford.EDU...
>

>>Have mercy.  We're starting to learn Oracle 9.0.1 here.
>>Until now I have done everything from the DBI account,
>>since I was working alone.  Now there's somebody else
>>and we want to set up user accounts properly.  I made
>>one for the new guy with
>>  create user joeuser identified by <password>;
>>So far so good.  I can modify the password with ALTER
>>USER.  But it seems like good practice to allow him to
>>set his own password.  I can't figure out how to do
>>that.  Probably it would require granting him some
>>privilege or role, but I haven't been able to figure
>>out which one.  Can someone illuminate me?
>>
>>--
>>*   Patrick L. Nolan                                          *
>>*   W. W. Hansen Experimental Physics Laboratory (HEPL)       *
>>*   Stanford University                                       *