• Run 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 membership tab.
• 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.

• Click OK.