Re: Newbie: User needs to change password

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 *
Received on Tue Feb 25 2003 - 05:27:44 CST