Article Details
Id:15642
Product:finPOWER Connect
Type:FIX
Version:3.01.08
Opened:27/03/2018
Closed:26/10/2018
Released:13/12/2018
Job: J020450

SQL Server Database provider; Permissions Reset fails under AWS RDS

The SQL Server Database provider fails to reset Permissions under AWS RDS because it doesn't allow granting of backup permissions.

Previously the command "GRANT CREATE VIEW, BACKUP DATABASE, BACKUP LOG TO public" was issued, and if it failed the whole function failed.

Now each of these three commands are issued separately, and they do not fail the overall function, i.e. the code continues unaffected.

Note, the same changes have been applied to the SQL Server Azure Database provider.