Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Newbie: User needs to change password
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?
--Received on Mon Feb 24 2003 - 20:45:00 CST
* Patrick L. Nolan *
* W. W. Hansen Experimental Physics Laboratory (HEPL) *
* Stanford University *
![]() |
![]() |