Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Richmond, VA
    Posts
    8

    Unanswered: How can I get secure passwords in tables?

    I've got a few good encryption algorithms, but I'm hoping I can find something Oracle specific that is SQL based. I'm looking for something similar to the PASSWORD function in MySQL. I want to be able to encrypt/decrypt passwords from my user table. Is there anything to do this in Oracle 9i?

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Do You want to decrypt the encrypted password?
    You can get the encrypted password from the DBA_USERS;

    PHP Code:
       SELECT usernamepassword
       FROM dba_users

    GOOD LUCK!!!
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Feb 2004
    Location
    Richmond, VA
    Posts
    8
    Yes, I'll need to be able to compare their user name/password combo when they log into the system. The users I speak of are not database users, but users I've stored in a table for my application.

  4. #4
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    You will need to use the DBMS_OBFUSCATION_TOOLKIT.

    JoeB

  5. #5
    Join Date
    Feb 2004
    Location
    Richmond, VA
    Posts
    8
    Does that come by default in Oracle or will I need to install something on the server?

Posting Permissions

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