Extra admin login permissions

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

See "System Status" in the IBM® Tealeaf cxImpact Administration Manual.

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

USE MASTER
GO

EXEC sp_grantdbaccess 'TLADMIN';

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

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