Expand the Jobs node, right click on Unassigned tasks and select New Task.
Create a Workflow Stored Procedure Task and give it a Name e.g. Update SDW User password
Select the Spatial Data WarehouseConnection, Click on the Astun radio button and select the Functionat_wkf_executecmd.
Enter the following in the Edit parameter 'cmdtoexecute' box, replacinguserandpasswordwith the name and password for the user whose password you wish to change.
ALTER USER "user" WITH PASSWORD 'password';
Click the Run button to run the task. You should see the dialog SPTask 'Update SDW User password' completed successfully. Click OK.
to run the task. You should see the dialog SPTask 'Update SDW User password' completed successfully. Click OK.