• Yes, This wxactly what I want..

    But, Here is the thing, The first document which you have provided me, as you know I suceessfully understood it and appield it too.

    No I can see two columns like AccountNumber, and EncryptedAccountNumber,

    In short, table has now one more column , called EncryptedAccountNumber, which has encrypted sensitive data,

    so what I should do with original column(AccountNumber), Which I don't want other member to see it.

    As my role is, I can do any DDL and DML operation in this server instant, which is same as my co-worker

    and I also told one of my co-worker to check from his account via accessing the same database and the same table, and I found out he can still see both AccountNumber, and EncryptedAccountNumber columns which doesn't solve the purpose.

    I am just missing somthing at some point, otherwise I know this thing should not happen.

    Thanks again, in advance for your time and support.