Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: Alter sys and system

    I want to give the ability to change password in oracle to a particular user, but at the same time I don't want this id to be able to change the password for the Sys and the System..What's the best way to achive this...

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713
    Any user can change their own password (unless) you have rovoked the ALTER USER privilege.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    To add to the earlier reply, a user with SQL*PLUS can issue the PASSWORD command to change their own password. After they login to SQL*PLUS they type PASSWORD and hit return. It will prompt for the old and new passwords. This command will not allow them to change anyone elses password, unless you grant special privs. Users with ALTER ANY USER can change other users' passwords.

    There was a bug in 817 related to using the ALTER USER command to change passwords for users whose profile has a password complixity verification function associated with it. I don't know if it was fixed, but I recall Oracle telling us (at that time) to use the SQL*Plus PASSWORD command as a workaround.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •