How to encrypt password columns
442370Apr 19 2005 — edited Dec 12 2007I would like to create a table to store the username and password for all my application users. There are a problem with password encryption. When I create a table as follows,
create table usrmas
(username varchar2(10),
passwd varchar2(20))
All password from the passwd column will be disclosed when somebody query the table. It is not secure. Right?
When I tried to use the table dba_users, for example, there are a user scott with password tiger, I am fail to find a record when I type a sql as follows,
select *
from dba_users
where username = 'SCOTT'
and password = 'TIGER'
Please advice me how I can authenticate user. Thanks