Learner44 (7/22/2013)

---

yes you are right..it's all about my language barrier..as english is not my first language..I always find my self in backfoot , while explaning the situation , what I really want

I have working in SQL SERVER 2008 R2, which has 6 accounts(U01,U02,U03,U04,U05,U06) under one server name called "SQL SERVER MANAGMENT STUDIO\server23".

I am U02 user.

All our accounts have access on specific database and table (client)..

This table consists of columns list as clientID, clientName,clientSalary,clientAccountNumber.

I need to restrict the user U01,U03,U04,U05,U06 to see "clientAccountNumber" column in client table.

I mean, I don't want these users to see the real data inside the ""clientAccountNumber" column, instead of this I want them to see some emcrypted data.

Now can you suggest me the way to do this...Please...

My senior manager, asks me that he doesn;t want somthing like grant and revoke permisiion for all the users..

He needs either encryption or datamasking.

I hope this time I am more clear, and gave less hard time to you "Big Helpers" to understand my situation.

thanks.