sql server reporting services: Report Model and Security Filter -- sql server reporting services

Report Model and Security Filter

Michael Schwabl
12/30/2005 5:40:03 AM

sql server reporting services: I have a single database which will be shared by many customers.
So the idea was to design a "Report Model" and use Security Filters to make
sure that customers only see data belonging to them. Each tabel has a field
called ClientID.

How can one design a single report model which asures that each customer
only sees those records, belonging to him.

br, Michael

RE: Report Model and Security Filter

Michael Schwabl
1/3/2006 12:31:03 AM

Maybe I shoul be more specific:
Is the concept of security filters the right way to go?
Is it better to design a special Report Model for each customer, where the
entities are based on queries?

thx, for any help

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.