Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 17th, 2004, 01:58 PM
Registered User
Join Date: Mar 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to lucid
Default conceal data

hi guys, it's been very helpful with u guys. i have this problem.
   - if i want to make certain text field not visible, i can set the "conceal data" property of the text item at the property pallete to "yes".
       how can i also conceal this data on the database, so that it cannot be viewed from SqlPlus say, for instance if this is a password item.

Old April 20th, 2004, 08:20 PM
Authorized User
Join Date: Apr 2004
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts

If you want to store passwords in the database, you would generally want to encrypt them using the dbms_obfuscation_toolkit. Only people who are authorized to view the data should be given EXECUTE access on the procedure that decrypts the password. If you are storing passwords for an application that you're developing, you can be even more secure by hashing the password, which would make it possible for you to verify that the password a user enters is correct, but won't allow anyone to access the clear text password.

Generally, you can restrict access to columns by creating views that don't contain the sensitive columns and granting SELECT access only to those views.

Distributed Database Consulting, Inc.

Similar Threads
Thread Thread Starter Forum Replies Last Post
problem in e-mail structure sending data from data tiawebchd General .NET 3 May 5th, 2008 08:07 AM
Data Binding - Editing GridView Row Data desk_star BOOK: Professional ASP.NET 2.0 and Special Edition; ISBN: 978-0-7645-7610-2; ISBN: 978-0-470-04178-9 7 December 30th, 2007 11:07 AM
Transfering data from csv file to data base g_vamsi_krish ASP.NET 1.0 and 1.1 Professional 2 May 16th, 2006 11:58 PM
Binding to Filtered Data (or Data subsets) gdbjohnson C# 8 August 27th, 2004 01:59 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.