How to Set Supportworks Database Table Permissions

FAQ: How to Set Supportworks Database Table Permissions

When an analyst opens a form with Supportworks, checks will be made to ensure that the analyst has the necessary rights to view the data on the form. If a new database table has been created, either through an upgrade or customisation, it will be necessary to grant rights to analysts who will need to access a form containing data from the new table. If these rights have not been granted, a message similar to the following will be displayed.

New table rights either need to be added for each analyst;

1. Navigate to Service Desk View
2. Right Click on an Analyst
3. Select Properties
4. Select System Privileges
5. Within “Application Database Management Rights” find the table with no rights as shown below.
6. Expand the table and check the box for the appropriate right for the given analyst.

Or through the Security Profile functionality;

1. Navigate to Administration Menu
2. Select Manage Security Profiles
3. Select Profile that you wish to change
4. Within “Application Database Management Rights” find the table with no rights as shown below.
5. Expand the table and check the box for the appropriate right for the Security Profile.

Analysts will need to log out and back in again for the permission to take effect.