The reporting database free space reports in the Tealeaf Portal require "sys.sp_OACreate" related permissions. However, this is sometimes not possible as the 'sys.sp_OAGetProperty' of component 'Ole Automation Procedures' has been disabled in the security configuration.
This is an old method from the SQL 2000 era when it was hard to get information out of SQL Server. As modern versions have free space information available in the system catalog, can the sp_OA related calls be removed and replaced with something more native to the current SQL server versions?
Related document links:
"sys.sp_OACreate" related permissions : https://www.ibm.com/support/knowledgecenter/en/SS2MBL_9.0.2/cxImpactAdmin/CX/SQLSrvAdmin/AdditionalAdminLoginPermissions_28.html
'sys.sp_OAGetProperty' Disabled: https://www.ibm.com/support/knowledgecenter/en/SS2MBL_9.0.2/Troubleshooting/CX/TblS-TLDB/SQLServerBlocksAccessToProcedureSysSp_OAGetProperty_43.html
What is your industry? | Computer Services |
What is the idea priority? | Medium |