When I give user1 permission to view column1 and column2 and user2 to view also column3 - via Enterprise Manager at MS SQL database and then I create report that asks for usernames and contains all three fields - in first case it returns error, that user1 has a denied access to column3.

That is....logical.

However - how can I make one report for all users that would just hide the "denied" fields instead of trying to show them and yield error?

Thanks

You would need to use different sql statements-- based on the user rights.. (this can be done conditionally in a SP).



Hal Levy
I am here to help you, not do it for you.
That is, unless you hire me. I am looking for work.

[quote]Originally posted by Hal Levy
 You would need to use different sql statements-- based on the user rights.. (this can be done conditionally in a SP).

Can you give me an example in SQL considering the signed-in user?

Thank you.