04.03.2023
15:20
I'm trying to change attachment file name by adding signature at the beginning of the file name. Unfortunately Instance number is giving me only the number from autonumbering and when I'm trying to get signature from WFElementSignatures table I'm receiving "The SELECT permission was denied" error.
04.03.2023
19:56
Hi Przemysław,
can't you just use the WFD_Signature from WFElements?
Regarding the "Select permission was denied". In some version the "BPS_User" or so was added to the database, which is used for executing the sql statements. It has limited permissions by default. For example in one installation the CacheOrganizationStructureGroupRelations wasn't defined in the permissions and we needed to add select permissions for it.
It's probably the same with your error.
Best regards,
Daniel
