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 Unica 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.