How to limit the Data only for the user who is viewing the Report ?

[wyzer]

Hello,

We want to publish a Report for every salesperson in our Enterprise.

But each salesperson can't see ohter's sales, he can only sees his sales.

How can we do that please ?

I remember in Jaspersoft we was able to do it because each user had a Login, so we put a variable in the SQL code that gets the Login name and put it in the Where condition.

Thanks.

(sorry for my bad English, I'm French)

[sdjensen · Accepted solution]

You should use Row-level security for this.