PowerFAIDS Integration (PFI) 9.2.3
In 9.2.3, PFI is moved from a stand-alone IIS site to the Web Administration sites (UI and Services). After upgrading, you may notice that user webadmin, used by Web Administration Services, doesn't have enough rights to manage PFI SQL Agent Jobs.
To fix this, grant SELECT on sysjobs in msdb and add to SQLAgentUserRole:
USE msdb
GO
GRANT SELECT ON [sysjobs] TO [webadmin];
ALTER ROLE [SQLAgentUserRole] ADD MEMBER [webadmin];
Looking for the PowerFAIDS Integration access link under System Administrator > Tools > Setup? It's now named Web Administration.
No comments to display
No comments to display