Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004

    Unanswered: Change password for SYSDBA - Oracle 9i

    Can anyone tell me how to setup the password for SYSDBA ? I've tried ALTER USER SYS as well as ALTER ROLE SYSDBA (it is apparently not a role) and other commands like that. I've read quite a part of the Oracle documentation but haven't found the document/section dealing with that matter. I seem to be able to change every other password, but not the one for SYSDBA : when I connect as sysdba, I just strike ENTER and I'm connected. For now I'm in development phase so it is not much of a problem, but I want to change this absolutely before we enter the production phase.

    Thanks in advance,


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    SYSDBA is NOT a schema/user; as such password can't be changed 'cuz it does not exist
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2003
    this should help.
    goto the passwordfile area.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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