Health Dashboard issue

After you upgrade to version 8.9, you cannot run the Health Dashboard report because of permissions issue.

Before you upgrade to version 8.9, you need to provide permissions to the data warehouse user as described in Preparing for upgrade. Follow this workaround if you have not provided permissions before upgrade.

Workaround: Provide the following permissions to the data warehouse user:

• GRANT SELECT ON dba_data_files TO datawarehouseUser
• GRANT SELECT ON  dba_free_space TO datawarehouseUser

After providing the permissions, compile the V_DB_SIZE view and then run the Health Dashboard report.