Creating a Standard User v2.0

This can be done via Studio or pgAdmin III

Using Studio

  1. Expand the Jobs node, right click on Unassigned tasks and select New Task.
     
  2. Create a Workflow Stored Procedure Task and give it a Name e.g. Create SDW User.

  3. Select the Spatial Data Warehouse Connection, Click on the All radio button and select the Function astun.sdw_new_userFrom v6.0.0 select astun from the Function filter and pick sdw_new_user.
     
  4. 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 and makeadmin (which should be false) parameters e.g.

    Ensure makeadmin is false.

     

  5. Click the Run button  to run the task. You should see the dialog SPTask 'Create SDW User' completed successfully. Click OK
     
  6. Click Save to save your new task details.

  7. Create a second Stored Procedure Task and give it a Name e.g. All database connection for User.

  8. Select the Spatial Data Warehouse Connection. Select Workflow from the Function filter and pick wkf_executecmd.

  9. Provide the following SQL as the cmdtoexecute parameter and run the task, changing the <user name> as required:

    grant connect on database sdw to <user_name>;


Using pgAdmin III

  1. Open pgAdmin III and connect to PostgreSQL as an Admin user.

  2. Click on the node for your Spatial Data Warehouse database (sdwin the tree view.
     
  3. Click on the SQL button  and launch the query window.

  4. Type the following command in the query pane changing the <user name> & <password> as required::

    SELECT astun.sdw_new_user('<user name>','<password>',false);


    e.g.


  5. Click on the green arrow 

    In the output message pane at the bottom you should see this:


  6. Type the following command in the query pane, changing the <user name> as required, and run by hitting F5 or selecting the Execute button:

    grant connect on database sdw to <user_name>;