anyone know how to validate an applications user login with either java, pl/sql, or even an sql statement? basically i want to take a username and password as plain text and look up their name in fnd_user and validate their password. i am guessing that i need to figure out the encryption algorithm and use it to encrypt the plain text and compare it to what is in the DB. or there may be a much simpler way to do this. any ideas?
