Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Newbie: User needs to change password

Newbie: User needs to change password

From: Patrick L. Nolan <pln_at_cosmic.stanford.edu>
Date: Tue, 25 Feb 2003 02:45:00 +0000 (UTC)
Message-ID: <b3elbc$dfn$1@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 Mon Feb 24 2003 - 20:45:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US