000037988 - How to Enable Advanced Workflow Actions by Email for all RSA Archer User Accounts

Document created by RSA Customer Support Employee on Oct 3, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037988
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.6 or higher
IssueAdvanced Workflow Actions by Email requires configuration on individual user accounts. This is a time consuming activity for large organizations wanting to enable the functionality for all user accounts. 
TasksRun the following SQL script against the Instance database to enable Advanced Workflow Actions by Email for all user accounts. The script excludes service accounts. 

UPDATE tblUser SET approve_content_by_email = 1 WHERE user_type_id IN (1,3)