I have some custom reports created through sql script on FNMSCompliance database.
But this is coming out with public visibility, while I'd like to have the possibility to change is to private.
Is it possible to change something, also at db level, to make it private?
Thanks
‎Mar 03, 2021 06:41 AM
Hi,
Check out the table ComplianceSavedSearch:
SELECT *
FROM ComplianceSavedSearch
There's the column RestrictedAccessTypeID, which refers to these values:
The column just before that referes to the creating operator and therefore who can see the report when private.
Best regards,
Markward
‎Mar 08, 2021 09:27 AM
This is interesting but does FNMS share users with its db? I mean, the report is created using an SQL script, so, can the user running scripts be considered the creator also on the web UI?
‎Mar 08, 2021 09:39 AM
Hi,
No, it looks like custom SQL-based reports do not get a CreatedByOperatorID by default. There's no option in the procedure:
So you'll have to change it after creating the report.
Best regards,
Markward
‎Mar 08, 2021 09:47 AM
‎Mar 08, 2021 10:10 AM
I think you should be able to set 2, but also make sure to identify the ID for the oprator who should "own" the report and then update that field as well.
‎Mar 08, 2021 10:46 AM