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.