Hi,

Thanks for those good articles. It solves my half purpose.

As there number of user for couple of tables , in which case we can not assign different roles to everybody, i guess, and also I can not create that many views from all those tables.

I want to upgrade my logic with your valuable help , what is the usefulness of the encryption which I performed on the particular column.?

I mean to say under my login id in SQL SERVER MANAGMENT STUDIO\server23, I created that master key, certificate and encrypted the data.

Now other users who works with me, also have the access to this same server instance, I just want them to see the table with enrcypted data in one column(Which I have encrypted). how I can achive this.?

Thanks in advance for your help.