Creating an Admin User v2.0

This can be done via Studio or pgAdmin |||

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 Admin User
     
  3. Select the Spatial Data Warehouse Connection, Click on the All radio button and select the Function astun.sdw_new_user. From 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 true) parameters e.g

    Ensure makeadmin is set to true.

     

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

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 (sdw) in the tree view.
     
  3. Click on the SQL button  and launch the query window.

  4. Type the following command in the query pane:

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

    e.g.


  5. Click on the green arrow 
    In the output message pane at the bottom you should see this: