Imposing column level security on a view for different user

> **Possible Duplicate:** > [Column level security](https://dba.stackexchange.com/questions/24292/column-level-security) I have a view which can be viewed by multiple users, and I would like to restrict some columns to specific users. e.g I have a view with fields A, B... F, and I have users P, Q, R, S. Here's what I am trying to implement: * when user P browses the view, he will see data in A, B, C and F, and columns D and E as NULL * when user Q browses the view, he will see data in all fields * when user R browses the view, he will see data in A, D, E and F, and columns B and C as NULL