Known issue: Access revoked to tables

Affects: All Jade versions

Best Practice Software has become aware of an issue causing partner Application Roles and SQL Logins to have incorrect permissions. This is separate to the recent issues with the October data update and affects all versions of Jade.

A nightly routine is executed as part of Bp Service that causes permissions to be revoked from several tables. The issue only occurs if de-identified access is normally granted to these tables.

Resolution

1. Download the DBRevokePermissionsFix.bpscript here.
2. Run the downloaded script on any Bp Premier server or workstation using the BP Script Runner Utility.