Granting / Removing Roles on Users V1.5

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.