You are 101% right..Sean

but, things here are ongoing..with millions of data across the 40+ tabels..

and account number is used as reference in almost 32+ tables.

Due to recent raise the quetions...

Hi Sean..

I use the following approach ro reference masked value to original values.

-- **********************************************

-- **************** STEP 1 ********************

-- **********************************************

update #ClientInfo

set ExistingID = floor(((ExistingID *...

Sean Lange (7/22/2013)

---

I agree with Steve that if this information is potentially sensitive then the system was designed poorly. This type of information should NOT be populated through a number...

Hi Sean AND Steve..

The following is totally not just to prove myself..but just got an idea in my mind, and want to discuss with you guys, before I waste my...

Thank you so much Steve and Sean.

As I was seraching for solution intially, when i got this task, i found single column encryption can be the best solution for this.

and...

I am not sure whether or not I am gonna make this solution or not, but as per your explaination,

You want me to do somthing like following.

1) pick column...

I completely agree with you Steve...As this is not the easy task.

I am fresh graduate...I know this very hard for me..as new to this orgranisation where , I am working...

I mean to say...

Can we add extra column in each table where "AccountNumber" column exists and apply somekind of algorithm, make modification in "AccountNumber" column data and make it unidentified...

Oh..no..:crying:

I am pretty sure that there will not be any way, once you said.

Is there any way we can solve from the scratch, or somthing else., because data is loaded...

Ok "BigHelpers" here is the main point,

I guess finally I came out with proper quetion, Please forgive me for any spelling mistakes...I am trying my best to get command on...

Hi Sean ...

can you please suggest me any way to achive the following objective.?

what should I do , in order to restrict other 5 users , having same access as...

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

Ok..I got your point Sean and Steve...Thanks for that.

I just checked the encryption from one of my co-worker, under her login name and password , but on the same server.

she...

Sean Lange (7/22/2013)

---

Why do you need to have both encrypted and clear text columns? This defeats the whole point of column level encryption. You haven't protected the sensitive information at...

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