>Hi All,
>
>Is there a way to encrypt specific column(s) in a table that not even the Admin user can view correctly without the encrpytion key, and the encryption key is controlled by the application that accesses the data and does things to the data?
>
>Is this possible?
>
>We want to encrypt some of our fields so that only our application can read the data correctly. We want to prevent competition from being able to access our data and use it with their application. Is this possible?
>
>TIA
>Beth
We encrypt passwords and other values in the application and all that the database server can see is gobbleygook. AFAIK, this is a pretty common practice.