Granting / Removing Roles on Users v2.0

Run pgAdmin III

1. Expand the Server details for the SDW server and login using an user with sdw_admin role.
    

2. Expand the Login Roles to show the entries.
    

3. Right-click on the user you have just created and select Properties.
    

4. Select the Role membership tab.
    

5. Select the relevant role in the Not Member box and click >> to add to the Member box. For restricted read-only access a user requires the restricted schema viewer role. For read/write access a user requires the restricted schema editor role.
   
   

   
   
   
   

   
   
   
   

6. Click OK.