How allow access only to selected data?

petr.pavlis · Post by **petr.pavlis** » Fri Jun 24, 2011 1:56 pm

Hello!

Within our web application we work with restricted data, that is why we need make available only data within reports for users to which they shall have an access. Some users shall have available only selected tables. Only selected table‘s columns shall be available for some users. Other users shall have access only to some records from table.

How suitably insert in application intermediate layer between MS SQL database and Stimulsoft Reports, which allows managing required accesses? Does it exist any other recommended solution this problem?

Is available any exemplary project demonstrating similar functionality?

Thank you

Post by **Andrew** » Tue Jun 28, 2011 2:15 pm

Hello,

You can implement this task in your Web application. Depending on the user, to receive data in the application and pass to a designer only the data which are necessary to a specific user, using the RegData method.

Thank you.

petr.pavlis · Post by **petr.pavlis** » Sun Sep 04, 2011 1:08 pm

Hellow Andrew,

But how can a web application to know which data needs to report? The application knows the tables which the user can work. But how to detect which tables (SQL Commands) are actually needed to generate the report?

Or can I implement my own DataProvider and not be dependent on the SQL DataProvider?

Thank you.

Post by **Alex K.** » Mon Sep 05, 2011 7:33 am

Hello,

Using these methods, you can find out which data sources are used in the report. And from the code you can load them only.

Code: Select all

StiBusinessObjectHelper.GetUsedBusinessObjectsNames(StiReport)
StiDataSourceHelper.GetUsedDataSourcesNames(StiReport)

Thank you.