Scheduled email of report - Roles/permissions needed

[simonezini]

Hi,
we've configured a scheduled sending of a report on the alm_hardware table (it is a multi-level pivot report), that is exported in PDF format. Then, we've set up a user in the "run as" field of the scheduled report, in order to let it run as a general user (not assigned to a real person).
However, if we set the field "Web service access only" to true for this user (sys_user.web_service_access_only), the report isn't exporting correctly (it is exported as in attachment "n1.png"). We need to set this field to false to correctly let the report run and export.

Is there any way we can leave this field set to true and at the same time have the report exporting correctly?
I've also tried leaving empty the field "run as" of the scheduled report, but I've got the same error as in attachment.

Thanks
Regards

Simone

[Maik Skoddow · Accepted solution]

So, in case we need a technical user just for scheduled job/report, we can use a normal user and set it as "Locked out=true"? 

-> exactly!

Do we need to give it some other rights or permissions?

-> it depends on which actions on which tables that user should perform. As the user cannot log in, you could give full rights. Or you create several users with different role sets.

Kind regards
Maik