Programmers sometimes need to store user password and some other fields in database data table in encrypted format. There exists an easy way to do this. I have used in my database. In my system, I have a table called Users which contains fields: UserID, UserName, Password,and Email. I have encrypted the password field.
[While continuing the journey, you may also be interested in implementing object relational database features of Oracle illustrated for a simple ecommerce database.]
With this scenario, I get following issues to be solved.Encrypt input password before inserting into data table.Decrypt password before reading it.
For all these requirements I use two functions, one for encrypting password and another for decrypting password.
--create two function: one for encrypt--the other for decrypt:
FUNCTION encrypt( iValue in varchar2, iKey in varchar2 )
-- encrypt input string
dbms_obfuscation_toolkit.desencrypt (input_string => iValue,
key_string => iKey,
encrypted_string => vEncrypted);
FUNCTION decrypt( iValue in varchar2, iKey in varchar2 )
-- decrypt input string
dbms_obfuscation_toolkit.desdecrypt (input_string => iValue,
key_string => iKey,
decrypted_string => vDecrypted);
Most of the times programmers fill the DataTable from database. This action fills the schema of the database table into the DataTable . We ...
The asp.net Eval() and Bind() expressions are heavily used in asp.net GridView and DetailsView data bound controls. The difference between ...
I have oracle database installed in my computer. My Operating system is XP. I wrote an application in asp.net. It connected to oracle databa...
Last time I got the following error: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related ...
We do have a folder (and a number of sub folders) with a number of various files in those folders (and sub folders). Now we do need to list ...
Much often we open child windows from parent web page . In the child page we perform some activities, and later close the window. At the ver...
The default behaviour of asp.net gridview is that it hides both Gridview header and footer when no data is present. You can note the absence...