Re: Can you encrypt a column value in Oracle?

dolans_at_stripe.Colorado.EDU (Sean Dolan) writes:

>
> I am trying to put a user's password in a table called USER_INFO in a column called PASSWORD... is there a way to have that value encrypted so that I can;t see the user's password? (but rather an encrypted garble)... I am on Oracle 7.3.4.
There is no built-in way to do it. However, I have seen PL/SQL routines that do encryption which could be used to encrypt the data prior to insertion. Check DejaNews.
--

                                        Rick
                                        Rick Wessman
                                        Distributed Data Security
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com