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".
    question:
       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.

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.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com