Is it possible to make use of the MSSQL Row level security functionality in Thinkwise? If so, where can I configure this?
Solved
Usage of MSSQL Row level security
- Captain
- 47 replies
Best answer by Anne Buit
Hi Peter,
The Thinkwise Platform does not support security predicates as this functionality is pretty much covered by locked prefilters and data authorization prefilters that you can configure in the Software Factory.
Keep in mind that in many situations, the database is not accessed directly by the user via a login present on the database. Instead, the database is accessed via a database pool service account.
This topic has been closed for comments
+5Hi Peter,
The Thinkwise Platform does not support security predicates as this functionality is pretty much covered by locked prefilters and data authorization prefilters that you can configure in the Software Factory.
Keep in mind that in many situations, the database is not accessed directly by the user via a login present on the database. Instead, the database is accessed via a database pool service account.
- Captain
- 47 replies
Hi Anne,
Thanks for the reply. I understand that when a user opens it via Thinkwise, it will filter it through the filters.However, when, for example, I have a report in SSRS, it still will show the data, right?
+5Yes, this is correct.
When developing the reports, you should take into account that the report is prepared under the database pool service account and that user-specific row-level authorization should be applied.
This also the case for object authorization - a report may use a table as data source that is not granted to the user requesting the report.
- Captain
- 47 replies
Thanks Anne!
I might can do it in the Dynamic model, I'll give it a try :)
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.