Scheduled email of report - Roles/permissions needed

simonezini
Mega Sage

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

1 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

View solution in original post

5 REPLIES 5

Maik Skoddow
Tera Patron
Tera Patron

Hi

a user with "Web service access only" is not intended to be used in scheduled reports. It is for external systems which have to integrate into ServiceNow.

So the better question is, why do use such an account for your scheduled report?

Kind regards
Maik

Hi Maik,

thanks for your reply.

We used the same user to run some scheduled jobs and which has also an admin role, so we thought to alos use it for scheduled reports.

Do we need to use 2 differents user, one to run scheduled reports and the other to run scheduled jobs?

Regards

Simone

Unfortunately, you have not answered my question "Why do use such an account for your scheduled report?".

If you need a technical user just for running scheduled jobs, you can take an account with "Locked out = true".

And again: "Web Service access only" users are external users and not meant to run internally

Kind regards
Maik

Initially, we've created that user as a normal user, then we needed to disable the possibility to login with that user and we set the "web service access only" field to true.

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"? Do we need to give it some other rights or permissions?

Thanks

Regards