[SOLVED]how to set limits on the number of records retrieve?
Hi,
My objective is to limit number of records that user can retrieve from DB in report. Reason for doing this is to avoid user try to retrieve huge amount of record from DB without set any filter.
did the trick, but some user may not want to coding in their .fex. Therefore, is there a way to set limitation and force only certain amount of records can be retrieve? or better if to have this limitation setting apply for certain user as well?
*User mention is the one on WebFOCUS user.This message has been edited. Last edited by: nox,
WebFOCUS v8.2.06 , Windows
August 06, 2020, 08:38 AM
MartinY
If I remember well DBA security setting in master file will allow you that
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
August 07, 2020, 05:53 AM
Danny-SRL
See: Describing Data With WebFOCUS Language Manual Chapter on Data Source Security
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
August 07, 2020, 06:07 AM
nox
I read up about DBA, but what I understand in DBA section can set limitation base on a field or column value to print the result, but what I looking for is more like set only MAX of 1,000 records can be retrieve without base on any column. Or is it there a way can be done in DBA section? if yes, then please provide some coding or where I should look into?
WebFOCUS v8.2.06 , Windows
August 07, 2020, 09:35 PM
sh98110
this is the poor man's Resource Governor solution: