- Open Studio
- 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. Create SDW UserAdmin
- Select the Spatial Data Warehouse Connection, Click on the Astun radio button and select the Function at_sdw_new_useradmin.
- Select the username parameter and enter the name of the user you wish to create by typing in the Edit parameter 'username' box. Repeat for the password parameter e.g.
...
- Click the Run button
to run the task. You should see the dialog SPTask 'Create SDW UserAdmin' created successfully. Click OK. - Click Save to save your new task details.
- Click the Run button
- Open pgAdmin III
- Expand the Server details for the SDW server and login using a superuser or administrator account.
- Expand the Login Roles to show the entries.
- Right-click on the user you have just created and select Properties.
- Select the Role privileges tab and tick the box Can create roles.
...