Extra admin login permissions

Through the Portal, database administrators can access useful reports on the state of the Discover databases.

See "System Status" in the HCL Discover Administration Manual.

To acquire all of the information to populate the Database Filegroup Size report, the DCADMIN account requires extra permissions. Below are the permissions to enable:

USE MASTER
GO

EXEC sp_grantdbaccess 'DCADMIN';

GRANT EXECUTE ON sys.sp_OACreate TO DCADMIN;
GRANT EXECUTE ON sys.sp_OADestroy TO DCADMIN;
GRANT EXECUTE ON sys.sp_OAGetErrorInfo TO DCADMIN;
GRANT EXECUTE ON sys.sp_OAGetProperty TO DCADMIN; 

If these permissions are not enabled or are not possible, the Database Filegroup Size contains a significant number of zeros in the data.