>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?

Sure you can put any value of the data type into a column without restraints.

Now having it used within a query in a join, where clause, or to group by? That is another area all together.

Where will the decryption take place, on the server side or bizObject layer?

__Stephen