what if scenario ???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: what if scenario ???

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    83

    Unhappy what if scenario ???

    hi all

    I was wondering what if a DBA forgets all the three main dba user accounts passwords ? How does he retreive the lost passwords ?
    I am talking about Users --> SYS
    SYSTEM
    INTERNAL


    Also as a dba if i query the dba_users, i see all users with their respective passwords column, but the passwords column is encrypted.
    Is there anyway can I see the actual password as a DBA of the database.

    thnankx
    ICEMAN

  2. #2
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    No - there is no way of seeing the unencrypted passwords. It's a good way of assuring the users that you don't know their passwords to explain this to them.

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by JMac
    No - there is no way of seeing the unencrypted passwords. It's a good way of assuring the users that you don't know their passwords to explain this to them.
    password in the password column of dba_users is not encrypted its hashed.

    and if you are on the server where the oracle database is then you dont need the password for sys as sysdba or internal if the os user is in dba group.

    and if you are use password file authentication then you can always use orapwd to change the sys password.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

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



Click Here to Expand Forum to Full Width