We are using the WebForms report viewer and I was wondering if there is a way to get SQL Server Row Level Security to work with Telerik Reports that have a SqlDatasource?
Is there a way to execute SP_SET_SESSION_CONTEXT before the SelectCommand is executed?
1 Answer, 1 is accepted
0
Hello Wei,
The reporting engine sends the contents of the CommandText property of the data source as a single SelectCommand, so it is not possible to execute another statement beforehand. However, a stored procedure that sets the session_context and then returns the data set should work.
Another approach is to replace the SqlDataSource with ObjectDataSource and in its data retrieval method to execute the necessary commands to configure the row security and then fetch the data from the database.
Regards,
Ivan Hristov
Progress Telerik
The reporting engine sends the contents of the CommandText property of the data source as a single SelectCommand, so it is not possible to execute another statement beforehand. However, a stored procedure that sets the session_context and then returns the data set should work.
Another approach is to replace the SqlDataSource with ObjectDataSource and in its data retrieval method to execute the necessary commands to configure the row security and then fetch the data from the database.
Regards,
Ivan Hristov
Progress Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items