return to PRS Technologies website

Elite Custom Report Security

Question: How do you set up security to control access to custom reports in Elite ?

If you want user access to look at the field win_cust . gen05, then in you have to put something like urept5>97 into that field.

So for example, if you do not want users who have uaccess.urept5 < 98 to be able to run a particular custom report, you would update win_cust as follows:

update win_cust set gen05="urept5>97" where reportid="[my report id]" and rectype="1"

So if a user with uaccess.urept5 of 97 of less tries to the run that report, Elite will not let them into the report. Other custom reports run just fine.