We are converting reports from Actuate to WebFocus. One of the reports uses Actuate's page-level-security feature that allows to limit the access of report's pages to particular users. The way page-level-security in Actuate works is that it allows to store a ACL (access control list) as a property of report's page/section. This ACL can be an expression or lits of userids populated by the report query. Can it be done in WebFocus? What can be other options in WebFocus?

Chandra

You can add security levels into the master that describes the dataset.
Next step will be a small script that should be included into the fex and that tests the user ID.
Based on the user ID the user will get the records he is allowed to see.

It sounds rather easy, but it needs a lot of thinking, and the problem I found is that the same user can have access to different tables on different levels.

What you are describing is a function of WebFOCUS Report Library. Reports would be scheduled via WF ReportCaster, and the output would be "bursted" based on values or distribution lists.

Check that out.