Windows Server - Encrypt/Decrypt numeric columns in Dexterity

Asked By Arun

22-Jan-10 10:27 AM

Hi All,

I have custom table created in dexterity having few numeric fields. I
do not want the data in those numeric fields to be viewed by the DB
Administrator by running  a select statement or by opening the table
in SQL server.

Is there a method in dexterity by which we can encrypt and decrypt
numeric fields ?
Or if I go for SQL 2005 encription method, whether dexterity can
handle it ?

Thanks in advance.

Arun

21-Jan-10 05:46 AM

Hi Arun,

While creating tables in dexterity, select the fields that you want to
encrypt in the "Table Fields" list and check the "Encrypt" checkbox.

Now those fields will be encrypted in the SQL.

Hope this helps you!

Thanks,
Prakash