Security Approach
To operate the Workbench software, network users must have database security rights to:
- the Workbench database(s)
- the Workbench Licence database
To achieve this, a SQL User Group is created called Workbench_Users, being the user group that was setup in the Pre-Requisites and Assumptions section
Granting Access rights to SQL Server
In SQL Studio Manager click on the security option
Select Logins
In the area displayed above right mouse click and select New Login
Click the search button
Type workbench_users in the box provided
Make sure that Groups is selected in the Object Types and the Location is your domain.
You can change Object Type by clicking the Object Types button.
or Location by clicking the Locations button
You should now have a screen that looks similar to the one below
Click OK
Grant Database Access
This section selects the databases over which the User Group Workbench_Users will have rights to access data
Select the User Mapping page
Select the Workbench databases that you need the users to have access to.
Typically this would be WorkbenchLive, WorkbenchTest, and WorkbenchLicence
Click OK
Database Rights (wbGrantPermissions)
Four users to use these databases, they need to be granted rights over them.
Rights to the selected databases are granted via a stored procedure called wbGrantPermissions.sql
In SQL Server click the new Query Button
In the Space provided type wbgrantpermissions '<Domain>\Workbench_Users'
Change the selected database to one of the Workbench databases you wish to grant rights to
Click Execute
When the process is complete, all the messages displayed will be in black. Any red messages are errors which need to be resolved. You may need to contact Workbench International Limited for assistance in resolving these.
This process must be repeated for all the Workbench databases you need to grant rights to, including the WorkbenchLicence database
The running of wbGrantPermissions is fundamental to the operation of Workbench.
Any new or updated stored procedures supplied by Workbench as part of an upgrade are run against the database as part of the upgrade process. The running of these stored procedures will automatically run the wbGrantPermissions.sql stored procedure as well, granting the required permissions.
If there is doubt at any time over rights to the database then run the command
wbgrantpermissions from the SQL Query option in SQL Server.
This will grant permissions on the selected database to users in the Group or Groups defined in the Control Parameter in Workbench called 'SQL User Logins', as displayed below.
When you have started Workbench, ensure that this Control Parameter is populated with 'Workbench_Users'