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.