yes...You are right..

In my tabel there is one column with sensitive data, called account number.

On which I successfully applied, coulmn encryption, after createing new coulmn called EncryptedAccountNumber.

Now My table show both original "AccounNumber" and EncryptedAccountNumber" column in select query.

I have to show to my boss that no other user can see that original column..while he/she looks into table.

I successfully applied to that column encryption.

We have our server name is like "SQSERVERSTUDIO\sqlserver2008" , and everybody has their own windows authentication,via which they login and access databases.

I am now stuck , how I can restrict other user with that specific table and specific column, which allows them to see only "EncrytedAccountNumber" column, not the actual "AccountNUmber"

and , here the enviornment is all the user can access same tables with its lates update by any other user, before that login.

Please help me.

Thanks.