Limiting data access based on login information ?

Here is what I want to do : we have on our network 250 stores. I want them to be able to access their P&L, sales, old invoices,... The trick is that I want each store to access his and only his information, without designing 250 times the same report with the store number as a preset value. Is there a way with SSRS to preset the "@.Store" parameter value based upon the login information ?

For this case I would implement row level security, because even if the parameter would be preset, user could gain access to other reports using the URl parameters. Therefore a implemented row level security, which filters out the appropiate value from the results with passing the Windows credentials would help you much more than that.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thks for your answer Jens. I m still quite a newbie with SQL... What are the basic steps to implement row level security ? Do you have to do it in your DB serving as datasource, or in the DB supporting SSRS ?

|||After understanding the principle of that , it should be easy for you to implement:

http://www.google.de/search?hl=de&q=row+level+security+sql+server&meta=

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de